1 INTRODUCCIÓN Y DEFINICIÓN DE OBJETIVOS

  • ¿Qué hace que un equipo gane un partido?
  • ¿Qué variables influyen en las victorias?
  • Predecir el ganador de un partido


# Librerías
library(dplyr)
library(tidyr)
library(knitr)
library(readr)
library(ggplot2)
library(cowplot)
library(GGally)




2 ANÁLISIS EXPLORATORIO INICIAL

laliga <- read_csv("combined_data_laliga.csv")
# primeros estadisticos de clase
str(laliga)
## spc_tbl_ [2,660 × 41] (S3: spec_tbl_df/tbl_df/tbl/data.frame)
##  $ ...1                         : num [1:2660] 0 1 2 3 4 5 6 7 8 9 ...
##  $ Home Team                    : chr [1:2660] "MÁLAGA" "SEVILLA FC" "GRANADA" "ALMERÍA" ...
##  $ Away Team                    : chr [1:2660] "ATHLETIC" "VALENCIA" "DEPORTIVO" "ESPANYOL" ...
##  $ Score                        : chr [1:2660] "1-0" "1-1" "2-1" "1-1" ...
##  $ Half Time Score              : chr [1:2660] "1-0" "1-0" "0-1" "0-0" ...
##  $ Match Excitement             : num [1:2660] 4.4 4.7 4.6 5.6 3.7 5.1 7 4.7 4.7 2.1 ...
##  $ Home Team Rating             : num [1:2660] 6 6.5 7.2 6.9 6.5 8 7.3 5.6 6.9 6.9 ...
##  $ Away Team Rating             : num [1:2660] 5.7 6.8 5.9 5.5 5.9 5.3 5.5 7.3 5.5 5.9 ...
##  $ Home Team Possession %       : num [1:2660] 40 47 53 56 41 72 59 53 63 59 ...
##  $ Away Team Possession %       : num [1:2660] 60 53 47 44 59 28 41 47 37 41 ...
##  $ Home Team Off Target Shots   : num [1:2660] 5 4 6 7 5 5 4 4 3 5 ...
##  $ Home Team On Target Shots    : num [1:2660] 3 3 3 6 5 6 9 2 8 2 ...
##  $ Home Team Total Shots        : num [1:2660] 12 12 10 19 12 12 20 9 14 8 ...
##  $ Home Team Blocked Shots      : num [1:2660] 4 5 1 6 2 1 7 3 3 1 ...
##  $ Home Team Corners            : num [1:2660] 5 3 5 11 5 3 4 3 8 2 ...
##  $ Home Team Throw Ins          : num [1:2660] 13 20 25 26 28 23 21 16 25 23 ...
##  $ Home Team Pass Success %     : num [1:2660] 69 76 79 81 60 93 82 80 88 79 ...
##  $ Home Team Aerials Won        : num [1:2660] 11 13 20 19 29 2 27 19 23 21 ...
##  $ Home Team Clearances         : num [1:2660] 16 16 21 25 17 2 15 12 13 20 ...
##  $ Home Team Fouls              : num [1:2660] 13 23 13 8 13 11 19 11 9 13 ...
##  $ Home Team Yellow Cards       : num [1:2660] 3 4 1 3 4 0 4 1 1 2 ...
##  $ Home Team Second Yellow Cards: num [1:2660] 0 0 0 0 0 0 0 0 0 0 ...
##  $ Home Team Red Cards          : num [1:2660] 2 0 0 0 0 1 0 0 0 0 ...
##  $ Away Team Off Target Shots   : num [1:2660] 5 5 1 6 7 3 8 5 6 3 ...
##  $ Away Team On Target Shots    : num [1:2660] 5 1 1 2 4 0 3 6 2 2 ...
##  $ Away Team Total Shots        : num [1:2660] 12 11 8 12 19 3 12 12 8 9 ...
##  $ Away Team Blocked Shots      : num [1:2660] 2 5 6 4 8 0 1 1 0 4 ...
##  $ Away Team Corners            : num [1:2660] 4 3 3 7 6 1 4 4 5 4 ...
##  $ Away Team Throw Ins          : num [1:2660] 22 27 30 19 36 19 19 14 18 34 ...
##  $ Away Team Pass Success %     : num [1:2660] 84 79 76 70 75 81 74 78 79 68 ...
##  $ Away Team Aerials Won        : num [1:2660] 17 14 10 11 25 4 22 21 15 26 ...
##  $ Away Team Clearances         : num [1:2660] 14 16 14 20 20 17 7 18 27 15 ...
##  $ Away Team Fouls              : num [1:2660] 9 8 26 9 14 13 15 14 13 17 ...
##  $ Away Team Yellow Cards       : num [1:2660] 3 2 3 3 1 1 1 3 2 2 ...
##  $ Away Team Second Yellow Cards: num [1:2660] 0 0 0 1 0 0 0 0 0 0 ...
##  $ Away Team Red Cards          : num [1:2660] 0 1 0 0 0 0 0 0 0 0 ...
##  $ Home Team Goals Scored       : num [1:2660] 1 1 2 1 1 3 3 0 2 0 ...
##  $ Away Team Goals Scored       : num [1:2660] 0 1 1 1 0 0 1 2 0 0 ...
##  $ Home Team Goals Conceeded    : num [1:2660] 0 1 1 1 0 0 1 2 0 0 ...
##  $ Away Team Goals Conceeded    : num [1:2660] 1 1 2 1 1 3 3 0 2 0 ...
##  $ year                         : num [1:2660] 2014 2014 2014 2014 2014 ...
##  - attr(*, "spec")=
##   .. cols(
##   ..   ...1 = col_double(),
##   ..   `Home Team` = col_character(),
##   ..   `Away Team` = col_character(),
##   ..   Score = col_character(),
##   ..   `Half Time Score` = col_character(),
##   ..   `Match Excitement` = col_double(),
##   ..   `Home Team Rating` = col_double(),
##   ..   `Away Team Rating` = col_double(),
##   ..   `Home Team Possession %` = col_double(),
##   ..   `Away Team Possession %` = col_double(),
##   ..   `Home Team Off Target Shots` = col_double(),
##   ..   `Home Team On Target Shots` = col_double(),
##   ..   `Home Team Total Shots` = col_double(),
##   ..   `Home Team Blocked Shots` = col_double(),
##   ..   `Home Team Corners` = col_double(),
##   ..   `Home Team Throw Ins` = col_double(),
##   ..   `Home Team Pass Success %` = col_double(),
##   ..   `Home Team Aerials Won` = col_double(),
##   ..   `Home Team Clearances` = col_double(),
##   ..   `Home Team Fouls` = col_double(),
##   ..   `Home Team Yellow Cards` = col_double(),
##   ..   `Home Team Second Yellow Cards` = col_double(),
##   ..   `Home Team Red Cards` = col_double(),
##   ..   `Away Team Off Target Shots` = col_double(),
##   ..   `Away Team On Target Shots` = col_double(),
##   ..   `Away Team Total Shots` = col_double(),
##   ..   `Away Team Blocked Shots` = col_double(),
##   ..   `Away Team Corners` = col_double(),
##   ..   `Away Team Throw Ins` = col_double(),
##   ..   `Away Team Pass Success %` = col_double(),
##   ..   `Away Team Aerials Won` = col_double(),
##   ..   `Away Team Clearances` = col_double(),
##   ..   `Away Team Fouls` = col_double(),
##   ..   `Away Team Yellow Cards` = col_double(),
##   ..   `Away Team Second Yellow Cards` = col_double(),
##   ..   `Away Team Red Cards` = col_double(),
##   ..   `Home Team Goals Scored` = col_double(),
##   ..   `Away Team Goals Scored` = col_double(),
##   ..   `Home Team Goals Conceeded` = col_double(),
##   ..   `Away Team Goals Conceeded` = col_double(),
##   ..   year = col_double()
##   .. )
##  - attr(*, "problems")=<externalptr>
summary(laliga) #medias y medianas son bastante similares, asi que se pueden analizar como normales
##       ...1         Home Team          Away Team            Score          
##  Min.   :   0.0   Length:2660        Length:2660        Length:2660       
##  1st Qu.: 664.8   Class :character   Class :character   Class :character  
##  Median :1329.5   Mode  :character   Mode  :character   Mode  :character  
##  Mean   :1329.5                                                           
##  3rd Qu.:1994.2                                                           
##  Max.   :2659.0                                                           
##  Half Time Score    Match Excitement Home Team Rating Away Team Rating
##  Length:2660        Min.   : 1.400   Min.   : 2.800   Min.   : 3.000  
##  Class :character   1st Qu.: 3.900   1st Qu.: 5.700   1st Qu.: 5.400  
##  Mode  :character   Median : 5.100   Median : 6.400   Median : 6.000  
##                     Mean   : 5.249   Mean   : 6.369   Mean   : 6.045  
##                     3rd Qu.: 6.300   3rd Qu.: 6.900   3rd Qu.: 6.600  
##                     Max.   :10.000   Max.   :10.000   Max.   :10.000  
##  Home Team Possession % Away Team Possession % Home Team Off Target Shots
##  Min.   :18.00          Min.   :17.00          Min.   : 0.000            
##  1st Qu.:44.00          1st Qu.:41.00          1st Qu.: 4.000            
##  Median :52.00          Median :48.00          Median : 5.000            
##  Mean   :51.54          Mean   :48.46          Mean   : 5.533            
##  3rd Qu.:59.00          3rd Qu.:56.00          3rd Qu.: 7.000            
##  Max.   :83.00          Max.   :82.00          Max.   :18.000            
##  Home Team On Target Shots Home Team Total Shots Home Team Blocked Shots
##  Min.   : 0.000            Min.   : 2.00         Min.   : 0.000         
##  1st Qu.: 3.000            1st Qu.:10.00         1st Qu.: 1.000         
##  Median : 4.000            Median :13.00         Median : 3.000         
##  Mean   : 4.648            Mean   :13.08         Mean   : 2.913         
##  3rd Qu.: 6.000            3rd Qu.:16.00         3rd Qu.: 4.000         
##  Max.   :17.000            Max.   :33.00         Max.   :12.000         
##  Home Team Corners Home Team Throw Ins Home Team Pass Success %
##  Min.   : 0.000    Min.   : 5.0        Min.   :46.00           
##  1st Qu.: 3.000    1st Qu.:18.0        1st Qu.:73.00           
##  Median : 5.000    Median :22.0        Median :78.00           
##  Mean   : 5.395    Mean   :22.5        Mean   :77.71           
##  3rd Qu.: 7.000    3rd Qu.:27.0        3rd Qu.:84.00           
##  Max.   :20.000    Max.   :49.0        Max.   :93.00           
##  Home Team Aerials Won Home Team Clearances Home Team Fouls
##  Min.   : 2.0          Min.   : 1.00        Min.   : 1.00  
##  1st Qu.:12.0          1st Qu.:12.00        1st Qu.:11.00  
##  Median :16.0          Median :17.00        Median :14.00  
##  Mean   :17.1          Mean   :17.71        Mean   :13.75  
##  3rd Qu.:22.0          3rd Qu.:22.00        3rd Qu.:16.00  
##  Max.   :52.0          Max.   :61.00        Max.   :33.00  
##  Home Team Yellow Cards Home Team Second Yellow Cards Home Team Red Cards
##  Min.   :0.000          Min.   :0.00000               Min.   :0.00000    
##  1st Qu.:1.000          1st Qu.:0.00000               1st Qu.:0.00000    
##  Median :2.000          Median :0.00000               Median :0.00000    
##  Mean   :2.417          Mean   :0.05602               Mean   :0.04699    
##  3rd Qu.:3.000          3rd Qu.:0.00000               3rd Qu.:0.00000    
##  Max.   :8.000          Max.   :2.00000               Max.   :2.00000    
##  Away Team Off Target Shots Away Team On Target Shots Away Team Total Shots
##  Min.   : 0.00              Min.   : 0.000            Min.   : 0.00        
##  1st Qu.: 3.00              1st Qu.: 2.000            1st Qu.: 7.00        
##  Median : 4.00              Median : 3.000            Median :10.00        
##  Mean   : 4.32              Mean   : 3.669            Mean   :10.36        
##  3rd Qu.: 6.00              3rd Qu.: 5.000            3rd Qu.:13.00        
##  Max.   :14.00              Max.   :13.000            Max.   :28.00        
##  Away Team Blocked Shots Away Team Corners Away Team Throw Ins
##  Min.   : 0.000          Min.   : 0.000    Min.   : 3.00      
##  1st Qu.: 1.000          1st Qu.: 2.000    1st Qu.:17.00      
##  Median : 2.000          Median : 4.000    Median :21.00      
##  Mean   : 2.391          Mean   : 4.215    Mean   :21.48      
##  3rd Qu.: 3.000          3rd Qu.: 6.000    3rd Qu.:26.00      
##  Max.   :13.000          Max.   :32.000    Max.   :45.00      
##  Away Team Pass Success % Away Team Aerials Won Away Team Clearances
##  Min.   :41.0             Min.   : 0.00         Min.   : 1.00       
##  1st Qu.:71.0             1st Qu.:11.00         1st Qu.:14.00       
##  Median :77.0             Median :16.00         Median :20.00       
##  Mean   :75.9             Mean   :16.75         Mean   :21.43       
##  3rd Qu.:82.0             3rd Qu.:21.00         3rd Qu.:27.00       
##  Max.   :93.0             Max.   :53.00         Max.   :63.00       
##  Away Team Fouls Away Team Yellow Cards Away Team Second Yellow Cards
##  Min.   : 0.00   Min.   :0.000          Min.   :0.00000              
##  1st Qu.:11.00   1st Qu.:2.000          1st Qu.:0.00000              
##  Median :13.00   Median :3.000          Median :0.00000              
##  Mean   :13.77   Mean   :2.641          Mean   :0.07744              
##  3rd Qu.:16.00   3rd Qu.:4.000          3rd Qu.:0.00000              
##  Max.   :30.00   Max.   :8.000          Max.   :2.00000              
##  Away Team Red Cards Home Team Goals Scored Away Team Goals Scored
##  Min.   :0.00000     Min.   : 0.000         Min.   :0.000         
##  1st Qu.:0.00000     1st Qu.: 1.000         1st Qu.:0.000         
##  Median :0.00000     Median : 1.000         Median :1.000         
##  Mean   :0.04887     Mean   : 1.518         Mean   :1.141         
##  3rd Qu.:0.00000     3rd Qu.: 2.000         3rd Qu.:2.000         
##  Max.   :2.00000     Max.   :10.000         Max.   :8.000         
##  Home Team Goals Conceeded Away Team Goals Conceeded      year     
##  Min.   :0.000             Min.   : 0.000            Min.   :2014  
##  1st Qu.:0.000             1st Qu.: 1.000            1st Qu.:2015  
##  Median :1.000             Median : 1.000            Median :2017  
##  Mean   :1.141             Mean   : 1.518            Mean   :2017  
##  3rd Qu.:2.000             3rd Qu.: 2.000            3rd Qu.:2019  
##  Max.   :8.000             Max.   :10.000            Max.   :2020

El dataframe contiene todos los partidos de la liga española de 7 temporadas (de 2014 a 2020).

  • 2660 observaciones (partidos)
  • 41 variables

Home Team: Equipo local
Away Team: Equipo visitante
Score: Resultado
Half Time Score: Resultado al descanso
Match Excitement: Emoción del partido (subjetiva)
Home Team Rating: Nota del local (subjetiva)
Away Team Rating: Nota del visitante (subjetiva)
Home Team Possession: Posesión local
Away Team Possession: Posesión visitante
Home Team off Target Shots: Tiros fuera local
Home Team on Target Shots: Tiros a puerta local
Home Team Total Shots: Total tiros local
Home Team Blocked Shots: Tiros bloqueados local
Home Team Corners: Corners local
Home Team Throw Ins: Centros local
Home Team Pass Success: Pases exitosos local
Home Team Aerials Won: Balones aereos ganados local
Home Team Clearences: Despejes local
Home Team Fouls: Faltas local
Home Team Yellow Cards: Amarillas local
Home Team Second Yellow Cards: Segundas amarillas local
Home Team Red Cards: Rojas local
Away Team off Target Shots: Tiros fuera visitante
Away Team on Target Shots: Tiros a puerta visitante
Away Team Total Shots: Total tiros visitante
Away Team Blocked Shots: Tiros bloqueados visitante
Away Team Corners: Corners visitante
Away Team Throw Ins: Centros visitante
Away Team Pass Success: Pases exitosos visitante
Away Team Aerials Won: Balones aereos ganados visitante
Away Team Clearences: Despejes visitante
Away Team Fouls: Faltas visitante
Away Team Yellow Cards: Amarillas visitante
Away Team Second Yellow Cards: Segundas amarillas visitante
Away Team Red Cards: Rojas visitante
Home Team Goals Scored: Goles local
Away Team Goals Scored: Goles visitante
Home Team Goals Conceeded: Goles visitante
Away Team Goals Conceeded: Goles local
Year: Año



3 LIMPIEZA DE DATOS

#Limpio los datos de las columnas quitando los espacios y cambiandolos por guiones, puesto que los espacios dan bastantes problemas a la hora de llamar a las variables
names(laliga) <- gsub(" ","_", names(laliga))
# Limpieza de variables que no nos interesan
laliga$Score <-  NULL
laliga$`Half_Time_Score` <- NULL
laliga$`Match_Excitement` <- NULL
laliga$`Home_Team_Rating` <- NULL
laliga$`Away_Team_Rating` <- NULL
laliga$`Home_Team_Goals_Conceeded` <- NULL
laliga$`Away_Team_Goals_Conceeded` <- NULL
# Añadimos la columna resultado (tipo quiniela)
laliga <- mutate(laliga, resultado = ifelse(Home_Team_Goals_Scored-Away_Team_Goals_Scored > 0, "1",
                                          ifelse(Home_Team_Goals_Scored-Away_Team_Goals_Scored < 0, "2", "x")))

# Añadimos la columna con los goles, tiros, tiros bloqueados, corners, centros, duelos aereos ganados, despejes, faltas, amarillas y rojas totales (por partido)
laliga <- mutate(laliga, goles = Home_Team_Goals_Scored + Away_Team_Goals_Scored)
laliga <- mutate(laliga, total_disparos = laliga$Home_Team_Total_Shots + laliga$Away_Team_Total_Shots)
laliga <- mutate(laliga, total_disparos_bloqueados = laliga$Home_Team_Blocked_Shots + laliga$Away_Team_Blocked_Shots)
laliga <- mutate(laliga, total_corners = laliga$Home_Team_Corners + laliga$Away_Team_Corners)
laliga <- mutate(laliga, total_centros = laliga$Home_Team_Throw_Ins + laliga$Away_Team_Throw_Ins)
laliga <- mutate(laliga, total_d_aereos = laliga$Home_Team_Aerials_Won + laliga$Away_Team_Aerials_Won)
laliga <- mutate(laliga, total_despejes = laliga$Home_Team_Clearances + laliga$Away_Team_Clearances)
laliga <- mutate(laliga, total_faltas = laliga$Home_Team_Fouls + laliga$Away_Team_Fouls)
laliga <- mutate(laliga, total_amarillas = laliga$Home_Team_Yellow_Cards + laliga$Away_Team_Yellow_Cards)
laliga <- mutate(laliga, total_rojas = laliga$Home_Team_Red_Cards + laliga$Away_Team_Red_Cards)


#Añadimos las columnas Home points y Away points
laliga <- mutate(laliga, Home_points = case_when(laliga$resultado == 1 ~ 3,
                                                 laliga$resultado == "x" ~ 1,
                                                 laliga$resultado == 2 ~ 0))
laliga <- mutate(laliga, Away_points = case_when(laliga$resultado == 1 ~ 0,
                                                 laliga$resultado == "x" ~ 1,
                                                 laliga$resultado == 2 ~ 3))
#añadimos una columna con la jornada
laliga <- mutate(laliga, jornada = ceiling(row_number() / 10)) %>%
        mutate(jornada = (jornada - 1) %% 38 + 1)
# Convertimos a categorias
laliga$Home_Team <- as.factor(laliga$Home_Team)
laliga$Away_Team <- as.factor(laliga$Away_Team)
laliga$resultado <- as.factor(laliga$resultado)




# Dividimos los datos en dos datasets (train y test)
test <- filter(laliga, year==2020)
train <- filter(laliga, year<2020)
#write.csv(test,"test/test_laliga.csv")
#write.csv(train,"train/train_laliga.csv")
# dataframes separados por resultado
Victorias_casa <- train %>% filter(resultado==1)
Derrotas_casa <- train %>% filter(resultado==2)
Empates <- train %>% filter(resultado=="x")




4 ANÁLISIS

train %>% select(25:35) %>%
  ggpairs(aes(color = resultado, alpha = .5))

4.1 RESUMEN NUMERICO

4.1.1 VARIABLES CUALITATIVAS

# de aqui sacamos los equipos que ha jugado cada equipo (más años en primera division)
as.data.frame(table(train$Home_Team) + table(train$Away_Team)) %>% arrange(desc(Freq))
##               Var1 Freq
## 1         ATHLETIC  228
## 2  ATLETICO MADRID  228
## 3        BARCELONA  228
## 4            CELTA  228
## 5            EIBAR  228
## 6         ESPANYOL  228
## 7      REAL MADRID  228
## 8    REAL SOCIEDAD  228
## 9       SEVILLA FC  228
## 10        VALENCIA  228
## 11      VILLARREAL  228
## 12          GETAFE  190
## 13         LEVANTE  190
## 14      REAL BETIS  190
## 15          ALAVÉS  152
## 16       DEPORTIVO  152
## 17         GRANADA  152
## 18         LEGANÉS  152
## 19          MÁLAGA  152
## 20      LAS PALMAS  114
## 21  RAYO VALLECANO  114
## 22           GIJÓN   76
## 23          GIRONA   76
## 24         OSASUNA   76
## 25      VALLADOLID   76
## 26         ALMERÍA   38
## 27         CÓRDOBA   38
## 28           ELCHE   38
## 29          HUESCA   38
## 30        MALLORCA   38
## 31        CÁDIZ CF    0
# aqui vemos cuantos partidos han ganado, empatado y perdido cada equipo
with(train, table(Home_Team, resultado))
##                  resultado
## Home_Team          1  2  x
##   ALAVÉS          30 23 23
##   ALMERÍA          3  9  7
##   ATHLETIC        56 24 34
##   ATLETICO MADRID 82  9 23
##   BARCELONA       94  7 13
##   CÁDIZ CF         0  0  0
##   CELTA           47 33 34
##   CÓRDOBA          1 12  6
##   DEPORTIVO       20 31 25
##   EIBAR           48 42 24
##   ELCHE            6 10  3
##   ESPANYOL        46 37 31
##   GETAFE          40 30 25
##   GIJÓN           12 18  8
##   GIRONA          11 18  9
##   GRANADA         24 30 22
##   HUESCA           5  8  6
##   LAS PALMAS      21 23 13
##   LEGANÉS         26 27 23
##   LEVANTE         35 31 29
##   MÁLAGA          30 29 17
##   MALLORCA         8  8  3
##   OSASUNA          9 15 14
##   RAYO VALLECANO  21 24 12
##   REAL BETIS      39 30 26
##   REAL MADRID     86 12 16
##   REAL SOCIEDAD   52 34 28
##   SEVILLA FC      74 15 25
##   VALENCIA        60 20 34
##   VALLADOLID      10 13 15
##   VILLARREAL      60 29 25
with(train, table(Away_Team, resultado))
##                  resultado
## Away_Team          1  2  x
##   ALAVÉS          42 22 12
##   ALMERÍA         13  5  1
##   ATHLETIC        53 32 29
##   ATLETICO MADRID 24 55 35
##   BARCELONA       16 72 26
##   CÁDIZ CF         0  0  0
##   CELTA           58 26 30
##   CÓRDOBA         12  2  5
##   DEPORTIVO       37  9 30
##   EIBAR           56 23 35
##   ELCHE            9  5  5
##   ESPANYOL        58 25 31
##   GETAFE          45 23 27
##   GIJÓN           22  5 11
##   GIRONA          16 12 10
##   GRANADA         46 13 17
##   HUESCA          11  2  6
##   LAS PALMAS      40  6 11
##   LEGANÉS         44 13 19
##   LEVANTE         57 18 20
##   MÁLAGA          45 13 18
##   MALLORCA        15  1  3
##   OSASUNA         21  8  9
##   RAYO VALLECANO  35 11 11
##   REAL BETIS      51 24 20
##   REAL MADRID     22 70 22
##   REAL SOCIEDAD   53 34 27
##   SEVILLA FC      48 37 29
##   VALENCIA        48 37 29
##   VALLADOLID      18  9 11
##   VILLARREAL      41 39 34
#sacar porcentaje de victorias de cada equipo y ordenar por eso
#numero y proporcion de victorias, derrotas y empates
table(train$resultado)
## 
##    1    2    x 
## 1056  651  573
prop.table(table(train$resultado))
## 
##         1         2         x 
## 0.4631579 0.2855263 0.2513158
# victorias, derrotas y empates de cada equipo
with(train, table(resultado, Home_Team))
##          Home_Team
## resultado ALAVÉS ALMERÍA ATHLETIC ATLETICO MADRID BARCELONA CÁDIZ CF CELTA
##         1     30       3       56              82        94        0    47
##         2     23       9       24               9         7        0    33
##         x     23       7       34              23        13        0    34
##          Home_Team
## resultado CÓRDOBA DEPORTIVO EIBAR ELCHE ESPANYOL GETAFE GIJÓN GIRONA GRANADA
##         1       1        20    48     6       46     40    12     11      24
##         2      12        31    42    10       37     30    18     18      30
##         x       6        25    24     3       31     25     8      9      22
##          Home_Team
## resultado HUESCA LAS PALMAS LEGANÉS LEVANTE MÁLAGA MALLORCA OSASUNA
##         1      5         21      26      35     30        8       9
##         2      8         23      27      31     29        8      15
##         x      6         13      23      29     17        3      14
##          Home_Team
## resultado RAYO VALLECANO REAL BETIS REAL MADRID REAL SOCIEDAD SEVILLA FC
##         1             21         39          86            52         74
##         2             24         30          12            34         15
##         x             12         26          16            28         25
##          Home_Team
## resultado VALENCIA VALLADOLID VILLARREAL
##         1       60         10         60
##         2       20         13         29
##         x       34         15         25
# proporcion de victorias, derrotas y empates de cada equipo
t((prop.table(with(train, table(resultado, Home_Team)), margin = 2)))*100
##                  resultado
## Home_Team                 1         2         x
##   ALAVÉS          39.473684 30.263158 30.263158
##   ALMERÍA         15.789474 47.368421 36.842105
##   ATHLETIC        49.122807 21.052632 29.824561
##   ATLETICO MADRID 71.929825  7.894737 20.175439
##   BARCELONA       82.456140  6.140351 11.403509
##   CÁDIZ CF                                     
##   CELTA           41.228070 28.947368 29.824561
##   CÓRDOBA          5.263158 63.157895 31.578947
##   DEPORTIVO       26.315789 40.789474 32.894737
##   EIBAR           42.105263 36.842105 21.052632
##   ELCHE           31.578947 52.631579 15.789474
##   ESPANYOL        40.350877 32.456140 27.192982
##   GETAFE          42.105263 31.578947 26.315789
##   GIJÓN           31.578947 47.368421 21.052632
##   GIRONA          28.947368 47.368421 23.684211
##   GRANADA         31.578947 39.473684 28.947368
##   HUESCA          26.315789 42.105263 31.578947
##   LAS PALMAS      36.842105 40.350877 22.807018
##   LEGANÉS         34.210526 35.526316 30.263158
##   LEVANTE         36.842105 32.631579 30.526316
##   MÁLAGA          39.473684 38.157895 22.368421
##   MALLORCA        42.105263 42.105263 15.789474
##   OSASUNA         23.684211 39.473684 36.842105
##   RAYO VALLECANO  36.842105 42.105263 21.052632
##   REAL BETIS      41.052632 31.578947 27.368421
##   REAL MADRID     75.438596 10.526316 14.035088
##   REAL SOCIEDAD   45.614035 29.824561 24.561404
##   SEVILLA FC      64.912281 13.157895 21.929825
##   VALENCIA        52.631579 17.543860 29.824561
##   VALLADOLID      26.315789 34.210526 39.473684
##   VILLARREAL      52.631579 25.438596 21.929825

10 equipos(Athletic, Atletico, Barcelona, Eibar, Espanyol, Real Madrid, Real Sociedad, Sevilla, Valencia y Villarreal) han estado todas las temporadas en primera.

4.1.2 VARIABLES CUANTITATIVAS

# Posesion
summary(train$`Home_Team_Possession_%`)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   19.00   44.00   52.00   51.68   59.00   83.00
summary(train$`Away_Team_Possession_%`)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   17.00   41.00   48.00   48.32   56.00   81.00
# Tiros
summary(train$Home_Team_Off_Target_Shots)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   0.000   4.000   5.000   5.635   7.000  18.000
summary(train$Away_Team_Off_Target_Shots)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   0.000   3.000   4.000   4.336   6.000  14.000
summary(train$Home_Team_On_Target_Shots)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   0.000   3.000   4.000   4.757   6.000  17.000
summary(train$Away_Team_On_Target_Shots)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   0.000   2.000   3.000   3.708   5.000  13.000
summary(train$Home_Team_Total_Shots)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##    2.00   10.00   13.00   13.36   16.00   33.00
summary(train$Away_Team_Total_Shots)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##    0.00    7.00   10.00   10.43   13.00   28.00
# Bloqueos
summary(train$Home_Team_Blocked_Shots)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   0.000   2.000   3.000   2.978   4.000  12.000
summary(train$Away_Team_Blocked_Shots)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   0.000   1.000   2.000   2.408   3.000  11.000
# Corners
summary(train$Home_Team_Corners)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   0.000   3.000   5.000   5.556   7.000  20.000
summary(train$Away_Team_Corners)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   0.000   2.000   4.000   4.202   6.000  32.000
# Centros
summary(train$Home_Team_Throw_Ins)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##    5.00   18.00   22.00   22.76   27.00   49.00
summary(train$Away_Team_Throw_Ins)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##    3.00   17.00   21.00   21.59   26.00   45.00
# Pases
summary(train$`Home_Team_Pass_Success_%`)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   46.00   73.00   78.00   77.64   83.00   93.00
summary(train$`Away_Team_Pass_Success_%`)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##    41.0    71.0    77.0    75.7    82.0    93.0
# Balones aereos
summary(train$Home_Team_Aerials_Won)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##    2.00   12.00   16.00   17.12   22.00   50.00
summary(train$Away_Team_Aerials_Won)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##    0.00   11.00   16.00   16.68   21.00   53.00
# Despejes
summary(train$Home_Team_Clearances)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##    1.00   12.00   17.00   18.01   23.00   61.00
summary(train$Away_Team_Clearances)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##    2.00   15.00   21.00   22.21   28.00   63.00
# Faltas
summary(train$Home_Team_Fouls)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##    1.00   11.00   14.00   13.82   17.00   33.00
summary(train$Away_Team_Fouls)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##    0.00   11.00   14.00   13.86   17.00   30.00
# Amarillas
summary(train$Home_Team_Yellow_Cards)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   0.000   1.000   2.000   2.465   3.000   8.000
summary(train$Away_Team_Yellow_Cards)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   0.000   2.000   3.000   2.707   4.000   8.000
# Rojas
summary(train$Home_Team_Second_Yellow_Cards)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
## 0.00000 0.00000 0.00000 0.05833 0.00000 2.00000
summary(train$Away_Team_Second_Yellow_Cards)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
## 0.00000 0.00000 0.00000 0.08202 0.00000 2.00000
# Rojas
summary(train$Home_Team_Red_Cards)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
## 0.00000 0.00000 0.00000 0.04561 0.00000 2.00000
summary(train$Away_Team_Red_Cards)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
## 0.00000 0.00000 0.00000 0.04868 0.00000 2.00000
# Goles
summary(train$goles)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   0.000   1.000   2.000   2.684   4.000  12.000
summary(train$goles)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   0.000   1.000   2.000   2.684   4.000  12.000

4.2 VISUALIZACION

4.2.1 VARIABLES CUALITATIVAS

ggplot(train, aes(resultado, fill = resultado)) +
  geom_bar() +
  labs(x = "Resultado", y = "Nº de resultados", title = "Nº de victorias Local / Visitante / Empate") + theme(plot.title = element_text(hjust = 0.5))

# se ve que jugar en casa es un factor importante para ganar (aprox. la mitad de partidos los gana el de casa)
ggplot(train, aes(Home_Team)) + geom_bar() + ggtitle("Núm. prof. por categoría")

ggplot(train,aes(resultado ,goles)) +
  geom_bar(position = "dodge", stat = "summary", fun = "mean",
           color = 'black', fill = 'green') +
  labs(title="Media de goles por partido", x="resultado", y="goles") +
  theme(plot.title=element_text(hjust = 0.5))

# en los partidos con victorias locales hay más goles de media que en los que gana el visitante (y bastante más que en los que hay empate). Por tanto, un partido con más goles es más probable que no acabe en empate.
ggplot(train,aes(resultado ,Home_Team_Goals_Scored)) +
  geom_bar(position = "dodge", stat = "summary", fun = "mean",
           color = 'black', fill = 'green') +
  labs(title="media de goles EQ. LOCAL por partido", x="resultado", y="goles local") +
  theme(plot.title=element_text(hjust = 0.5))

# Cuando el equipo local gana, mayor es su media de goles. Es decir, a mas goles, mas victorias (obvio pero habia que comprobarlo)
ggplot(train,aes(resultado ,Away_Team_Goals_Scored)) +
  geom_bar(position = "dodge", stat = "summary", fun = "mean",
           color = 'black', fill = 'green') +
  labs(title="media de goles EQ. VISITANTE por partido", x="resultado", y="goles visitante") +
  theme(plot.title=element_text(hjust = 0.5))

# Cuando el equipo local pierde, mayor es la media de goles del visitante. Es decir, a mas goles encajados, mas derrotas (obvio pero habia que comprobarlo)

4.2.2 VARIABLES CUANTITATIVAS

goles_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_goles = sum(goles)))
## Warning: `data_frame()` was deprecated in tibble 1.1.0.
## ℹ Please use `tibble()` instead.
tiros_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_tiros = sum(total_disparos)))
tiros_block_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_tiros_bloqueados = sum(total_disparos_bloqueados)))
corners_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_corners = sum(total_corners)))
centros_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_centros = sum(total_centros)))
d_aer_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_d_aer = sum(total_d_aereos)))
t_despj_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_despejes = sum(total_despejes)))
faltas_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_faltas = sum(total_faltas)))
amarll_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_amarillas = sum(total_amarillas)))
rojas_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_rojas = sum(total_rojas)))
ggplot(goles_year_jorn,  aes(x = jornada, y = total_goles)) + geom_point() + facet_grid(~year) + labs(x = "jornadas", y = "Nº de goles", title = "Nº de goles por jornada / Año") + theme(plot.title = element_text(hjust = 0.5)) + xlim(1,38)

ggplot(tiros_year_jorn,  aes(x = jornada, y = total_tiros)) + geom_point() + facet_grid(~year) + labs(x = "jornadas", y = "Nº de disparos", title = "Nº de disparos por jornada / Año") + theme(plot.title = element_text(hjust = 0.5))

ggplot(tiros_block_year_jorn,  aes(x = jornada, y = total_tiros_bloqueados)) + geom_point() + facet_grid(~year) + labs(x = "jornadas", y = "Nº de disparos_bloqueados", title = "Nº de disparos bloqueados por jornada / Año") + theme(plot.title = element_text(hjust = 0.5))

ggplot(corners_year_jorn,  aes(x = jornada, y = total_corners)) + geom_point() + facet_grid(~year) + labs(x = "jornadas", y = "Nº de corners", title = "Nº de corners por jornada / Año") + theme(plot.title = element_text(hjust = 0.5))

ggplot(centros_year_jorn,  aes(x = jornada, y = total_centros)) + geom_point() + facet_grid(~year) + labs(x = "jornadas", y = "Nº de centros", title = "Nº de centros por jornada / Año") + theme(plot.title = element_text(hjust = 0.5))

ggplot(t_despj_year_jorn,  aes(x = jornada, y = total_despejes)) + geom_point() + facet_grid(~year) + labs(x = "jornadas", y = "Nº de despejes", title = "Nº de despejes por jornada / Año") + theme(plot.title = element_text(hjust = 0.5))

ggplot(faltas_year_jorn,  aes(x = jornada, y = total_faltas)) + geom_point() + facet_grid(~year) + labs(x = "jornadas", y = "Nº de faltas", title = "Nº de faltas por jornada / Año") + theme(plot.title = element_text(hjust = 0.5))

ggplot(amarll_year_jorn,  aes(x = jornada, y = total_amarillas)) + geom_point() + facet_grid(~year) + labs(x = "jornadas", y = "Nº de tarj. Amarillas", title = "Nº de tarj. Amarillas por jornada / Año") + theme(plot.title = element_text(hjust = 0.5))

ggplot(rojas_year_jorn,  aes(x = jornada, y = total_rojas)) + geom_point() + facet_grid(~year) + labs(x = "jornadas", y = "Nº de tarj. Rojas", title = "Nº de tarj. Rojas por jornada / Año") + theme(plot.title = element_text(hjust = 0.5))



#Media de goles por partido
sum(train$Home_Team_Goals_Scored, train$Away_Team_Goals_Scored)/nrow(train)
## [1] 2.683772
#Media de goles por partido con victoria local
sum(Victorias_casa$Home_Team_Goals_Scored,Victorias_casa$Away_Team_Goals_Scored)/nrow(Victorias_casa)
## [1] 2.980114
#Media de goles por partido con victoria visitante
sum(Derrotas_casa$Home_Team_Goals_Scored,Derrotas_casa$Away_Team_Goals_Scored)/nrow(Derrotas_casa)
## [1] 2.826421
#Media de goles por partido con empate
sum(Empates$Home_Team_Goals_Scored,Empates$Away_Team_Goals_Scored)/nrow(Empates)
## [1] 1.975567



ggplot(train,aes(resultado , total_disparos)) +
  geom_bar(position = "dodge", stat = "summary", fun = "mean",
           color = 'black', fill = 'pink') +
  labs(title="Media de disparos por partido", x="resultado", y="disparos") +
  theme(plot.title=element_text(hjust = 0.5))

# en los partidos el numero total de disparos está bastante igualado con independencia de la victoria, derrota o empate.
ggplot(train,aes(resultado ,Home_Team_Total_Shots)) +
  geom_bar(position = "dodge", stat = "summary", fun = "mean",
           color = 'black', fill = 'pink') +
  labs(title="media de tiros EQ. LOCAL por partido", x="resultado", y="tiros local") +
  theme(plot.title=element_text(hjust = 0.5))

# El número de tiros no influye mucho en el resultado (gane, pierda o empate suelen ser similares)
ggplot(train,aes(resultado ,Home_Team_On_Target_Shots)) +
  geom_bar(position = "dodge", stat = "summary", fun = "mean",
           color = 'black', fill = 'pink') +
  labs(title="media de tiros a puerta EQ. LOCAL por partido", x="resultado", y="tiros a puerta local") +
  theme(plot.title=element_text(hjust = 0.5))

# Sin embargo el número de tiros a puerta si influye (cuantos más tiros a puerta, más cerca de la victoria)
ggplot(train,aes(resultado ,Away_Team_Total_Shots)) +
  geom_bar(position = "dodge", stat = "summary", fun = "mean",
           color = 'black', fill = 'pink') +
  labs(title="media de tiros EQ. VISITANTE por partido", x="resultado", y="tiros local") +
  theme(plot.title=element_text(hjust = 0.5))

# Igual que para el equipo local, el número de tiros no influye mucho en el resultado (gane, pierda o empate suelen ser similares)
ggplot(train,aes(resultado ,Away_Team_On_Target_Shots)) +
  geom_bar(position = "dodge", stat = "summary", fun = "mean",
           color = 'black', fill = 'pink') +
  labs(title="media de tiros a puerta EQ. VISITANTE por partido", x="resultado", y="tiros a puerta local") +
  theme(plot.title=element_text(hjust = 0.5))

# Sin embargo  volvemos a ver que el número de tiros a puerta si influye (cuantos más tiros a puerta, más cerca de la victoria)
#Media de disparos por partido
sum(train$Home_Team_Total_Shots, train$Away_Team_Total_Shots)/nrow(train)
## [1] 23.79035
#Media de disparos a puerta partido
sum(train$Home_Team_On_Target_Shots, train$Away_Team_On_Target_Shots)/nrow(train)
## [1] 8.465351
#Media de disparos bloqueados
sum(train$Home_Team_Blocked_Shots, train$Away_Team_Blocked_Shots)/nrow(train)
## [1] 5.385965



ggplot(train,aes(resultado ,`Home_Team_Possession_%`)) +
  geom_bar(position = "dodge", stat = "summary", fun = "mean",
           color = 'black', fill = 'orange') +
  labs(title="Gráfica Pep", x="resultado", y="posesion local") +
  theme(plot.title=element_text(hjust = 0.5))

# No parece influir mucho la posesión
ggplot(train,aes(resultado ,`Away_Team_Possession_%`)) +
  geom_bar(position = "dodge", stat = "summary", fun = "mean",
           color = 'black', fill = 'orange') +
  labs(title="Gráfica Pep", x="resultado", y="posesion visitante") +
  theme(plot.title=element_text(hjust = 0.5))

# El equipo local suele tener más posesion (>50%) independientemente del resultado



ggplot(train,aes(resultado ,total_disparos_bloqueados)) +
  geom_bar(position = "dodge", stat = "summary", fun = "mean",
           color = 'black', fill = "grey") +
  labs(title="Media de tiros bloqueados por partido", x="resultado", y="tiros bloqueados") +
  theme(plot.title=element_text(hjust = 0.5))

# El numero de disparos bloqueados no parece un factor determinante en la victoria



ggplot(train,aes(resultado ,total_d_aereos)) +
  geom_bar(position = "dodge", stat = "summary", fun = "mean",
           color = 'black', fill = "brown") +
  labs(title="Media de duelos aereos por partido", x="resultado", y="duelos aereos") +
  theme(plot.title=element_text(hjust = 0.5))

# El numero de duelos aereos no parece un factor determinante en la victoria



ggplot(train,aes(resultado ,total_corners)) +
  geom_bar(position = "dodge", stat = "summary", fun = "mean",
           color = 'black', fill = 'blue') +
  labs(title="Media de corners por partido", x="resultado", y="corners") +
  theme(plot.title=element_text(hjust = 0.5))

# El numero de corners no parece un factor determinante en la victoria se puede observar como con independencia del ganadar el numero de corners está muy repartido



ggplot(train,aes(resultado ,total_centros)) +
  geom_bar(position = "dodge", stat = "summary", fun = "mean",
           color = 'black', fill = 'lightblue') +
  labs(title="Media de centros por partido", x="resultado", y="centros") +
  theme(plot.title=element_text(hjust = 0.5))

# El numero de centros no parece un factor determinante en la victoria se puede observar como con independencia del ganadar el numero de centros está muy repartido



ggplot(train,aes(resultado ,total_despejes)) +
  geom_bar(position = "dodge", stat = "summary", fun = "mean",
           color = 'black', fill = 'lightgreen') +
  labs(title="Media de despejes por partido", x="resultado", y="despejes") +
  theme(plot.title=element_text(hjust = 0.5))

# El numero de despejes no parece un factor determinante en la victoria incluso parece que a mayor número de despejes medios el partido parece más probable que acabe en empate



ggplot(train,aes(resultado ,total_faltas)) +
  geom_bar(position = "dodge", stat = "summary", fun = "mean",
           color = 'black', fill = 'lightyellow') +
  labs(title="Media de faltas por partido", x="resultado", y="faltas") +
  theme(plot.title=element_text(hjust = 0.5))

# El numero de faltas no parece un factor determinante.



ggplot(train,aes(resultado ,total_amarillas)) +
  geom_bar(position = "dodge", stat = "summary", fun = "mean",
           color = 'black', fill = 'yellow') +
  labs(title="Media de amarillas por partido", x="resultado", y="amarillas") +
  theme(plot.title=element_text(hjust = 0.5))

# El numero de tarjetas amarillas no parece un factor determinante.



ggplot(train,aes(resultado ,total_rojas)) +
  geom_bar(position = "dodge", stat = "summary", fun = "mean",
           color = 'black', fill = 'red') +
  labs(title="Media de rojas por partido", x="resultado", y="rojas") +
  theme(plot.title=element_text(hjust = 0.5))

# El numero de tarjetas rojas no parece un factor determinante.



#Puntos promedio por partido por equipo
puntos_promedio_casa <- aggregate((Home_points) ~ Home_Team, data = train, mean)

puntos_promedio_fuera <- aggregate(Away_points ~ Away_Team, data = train, mean)

puntos_promedio <- data.frame(puntos_promedio_casa$Home_Team, (puntos_promedio_casa$`(Home_points)` + puntos_promedio_fuera$Away_points)/2)
names(puntos_promedio) <- c("Equipo", "Puntos_por_partido")
puntos_promedio
##             Equipo Puntos_por_partido
## 1           ALAVÉS          1.2565789
## 2          ALMERÍA          0.8421053
## 3         ATHLETIC          1.4342105
## 4  ATLETICO MADRID          2.0570175
## 5        BARCELONA          2.3552632
## 6            CELTA          1.2412281
## 7          CÓRDOBA          0.5263158
## 8        DEPORTIVO          0.9342105
## 9            EIBAR          1.1929825
## 10           ELCHE          1.0789474
## 11        ESPANYOL          1.2061404
## 12          GETAFE          1.2684211
## 13           GIJÓN          0.9210526
## 14          GIRONA          1.1578947
## 15         GRANADA          0.9868421
## 16          HUESCA          0.8684211
## 17      LAS PALMAS          0.9210526
## 18         LEGANÉS          1.0460526
## 19         LEVANTE          1.0947368
## 20          MÁLAGA          1.0789474
## 21        MALLORCA          0.8684211
## 22         OSASUNA          0.9736842
## 23  RAYO VALLECANO          1.0438596
## 24      REAL BETIS          1.2368421
## 25     REAL MADRID          2.2192982
## 26   REAL SOCIEDAD          1.3728070
## 27      SEVILLA FC          1.6973684
## 28        VALENCIA          1.5526316
## 29      VALLADOLID          1.0921053
## 30      VILLARREAL          1.5614035



#Esta seria la clasificacion con la media de puntos por partido por equipo
clasificacion_media <- arrange(puntos_promedio,desc(Puntos_por_partido))
clasificacion_media
##             Equipo Puntos_por_partido
## 1        BARCELONA          2.3552632
## 2      REAL MADRID          2.2192982
## 3  ATLETICO MADRID          2.0570175
## 4       SEVILLA FC          1.6973684
## 5       VILLARREAL          1.5614035
## 6         VALENCIA          1.5526316
## 7         ATHLETIC          1.4342105
## 8    REAL SOCIEDAD          1.3728070
## 9           GETAFE          1.2684211
## 10          ALAVÉS          1.2565789
## 11           CELTA          1.2412281
## 12      REAL BETIS          1.2368421
## 13        ESPANYOL          1.2061404
## 14           EIBAR          1.1929825
## 15          GIRONA          1.1578947
## 16         LEVANTE          1.0947368
## 17      VALLADOLID          1.0921053
## 18           ELCHE          1.0789474
## 19          MÁLAGA          1.0789474
## 20         LEGANÉS          1.0460526
## 21  RAYO VALLECANO          1.0438596
## 22         GRANADA          0.9868421
## 23         OSASUNA          0.9736842
## 24       DEPORTIVO          0.9342105
## 25           GIJÓN          0.9210526
## 26      LAS PALMAS          0.9210526
## 27          HUESCA          0.8684211
## 28        MALLORCA          0.8684211
## 29         ALMERÍA          0.8421053
## 30         CÓRDOBA          0.5263158



aggregate(Home_Team_Goals_Scored ~ Home_Team, data = train, FUN = mean) -> goles_home_team
goles_home_team
##          Home_Team Home_Team_Goals_Scored
## 1           ALAVÉS              1.0394737
## 2          ALMERÍA              1.0526316
## 3         ATHLETIC              1.4473684
## 4  ATLETICO MADRID              1.7982456
## 5        BARCELONA              3.0789474
## 6            CELTA              1.5438596
## 7          CÓRDOBA              0.6315789
## 8        DEPORTIVO              1.2631579
## 9            EIBAR              1.3771930
## 10           ELCHE              1.0000000
## 11        ESPANYOL              1.1929825
## 12          GETAFE              1.2421053
## 13           GIJÓN              1.4210526
## 14          GIRONA              1.1315789
## 15         GRANADA              1.0789474
## 16          HUESCA              1.2631579
## 17      LAS PALMAS              1.2807018
## 18         LEGANÉS              1.0131579
## 19         LEVANTE              1.3578947
## 20          MÁLAGA              1.2894737
## 21        MALLORCA              1.3157895
## 22         OSASUNA              1.2894737
## 23  RAYO VALLECANO              1.4035088
## 24      REAL BETIS              1.4000000
## 25     REAL MADRID              2.7105263
## 26   REAL SOCIEDAD              1.6140351
## 27      SEVILLA FC              1.8508772
## 28        VALENCIA              1.6491228
## 29      VALLADOLID              0.8947368
## 30      VILLARREAL              1.6666667
aggregate(Away_Team_Goals_Scored ~ Away_Team, data = train, FUN = mean) -> goles_Away_team
goles_Away_team
##          Away_Team Away_Team_Goals_Scored
## 1           ALAVÉS              0.9868421
## 2          ALMERÍA              0.7894737
## 3         ATHLETIC              0.9736842
## 4  ATLETICO MADRID              1.3947368
## 5        BARCELONA              2.2982456
## 6            CELTA              1.0877193
## 7          CÓRDOBA              0.5263158
## 8        DEPORTIVO              0.8552632
## 9            EIBAR              0.9736842
## 10           ELCHE              0.8421053
## 11        ESPANYOL              0.9736842
## 12          GETAFE              0.8947368
## 13           GIJÓN              0.7368421
## 14          GIRONA              1.1578947
## 15         GRANADA              0.9868421
## 16          HUESCA              1.0000000
## 17      LAS PALMAS              0.8596491
## 18         LEGANÉS              0.7894737
## 19         LEVANTE              0.9684211
## 20          MÁLAGA              0.7236842
## 21        MALLORCA              0.7894737
## 22         OSASUNA              0.9736842
## 23  RAYO VALLECANO              1.0350877
## 24      REAL BETIS              0.9894737
## 25     REAL MADRID              2.2105263
## 26   REAL SOCIEDAD              1.1491228
## 27      SEVILLA FC              1.2719298
## 28        VALENCIA              1.2807018
## 29      VALLADOLID              0.7894737
## 30      VILLARREAL              1.1140351
goles_por_equipo <- data.frame(goles_home_team$Home_Team,(goles_Away_team$Away_Team_Goals_Scored + goles_home_team$Home_Team_Goals_Scored)/2)
names(goles_por_equipo) <- c("equipo", "goles")
goles_por_equipo
##             equipo     goles
## 1           ALAVÉS 1.0131579
## 2          ALMERÍA 0.9210526
## 3         ATHLETIC 1.2105263
## 4  ATLETICO MADRID 1.5964912
## 5        BARCELONA 2.6885965
## 6            CELTA 1.3157895
## 7          CÓRDOBA 0.5789474
## 8        DEPORTIVO 1.0592105
## 9            EIBAR 1.1754386
## 10           ELCHE 0.9210526
## 11        ESPANYOL 1.0833333
## 12          GETAFE 1.0684211
## 13           GIJÓN 1.0789474
## 14          GIRONA 1.1447368
## 15         GRANADA 1.0328947
## 16          HUESCA 1.1315789
## 17      LAS PALMAS 1.0701754
## 18         LEGANÉS 0.9013158
## 19         LEVANTE 1.1631579
## 20          MÁLAGA 1.0065789
## 21        MALLORCA 1.0526316
## 22         OSASUNA 1.1315789
## 23  RAYO VALLECANO 1.2192982
## 24      REAL BETIS 1.1947368
## 25     REAL MADRID 2.4605263
## 26   REAL SOCIEDAD 1.3815789
## 27      SEVILLA FC 1.5614035
## 28        VALENCIA 1.4649123
## 29      VALLADOLID 0.8421053
## 30      VILLARREAL 1.3903509



#No he sido capaz de poner encima una grafica de densidad con los puntos de cada equipo 
ggplot(goles_por_equipo, aes(x = equipo, y = goles)) +
  geom_bar(position = "dodge", stat = "summary", fill = "darkred") +
  labs(title = "Comparación goles y puntos") +
  theme(plot.title = element_text(hjust = 0.5), axis.text.x = element_text(angle = 90))



#Porcentaje medio de posesión por equipo en casa
tapply(train$`Home_Team_Possession_%`,train$`Home_Team`,mean)
##          ALAVÉS         ALMERÍA        ATHLETIC ATLETICO MADRID       BARCELONA 
##        43.86842        45.42105        51.60526        50.35965        66.31579 
##        CÁDIZ CF           CELTA         CÓRDOBA       DEPORTIVO           EIBAR 
##              NA        56.37719        51.47368        49.11842        50.61404 
##           ELCHE        ESPANYOL          GETAFE           GIJÓN          GIRONA 
##        50.05263        48.02632        44.64211        45.89474        49.52632 
##         GRANADA          HUESCA      LAS PALMAS         LEGANÉS         LEVANTE 
##        46.69737        47.31579        58.73684        45.60526        46.25263 
##          MÁLAGA        MALLORCA         OSASUNA  RAYO VALLECANO      REAL BETIS 
##        48.85526        42.89474        45.47368        54.57895        55.57895 
##     REAL MADRID   REAL SOCIEDAD      SEVILLA FC        VALENCIA      VALLADOLID 
##        60.01754        55.49123        56.39474        49.71930        47.60526 
##      VILLARREAL 
##        51.55263



#Porcentaje medio de posesión por equipo fuera de casa
tapply(train$`Away_Team_Possession_%`,train$`Away_Team`,mean)
##          ALAVÉS         ALMERÍA        ATHLETIC ATLETICO MADRID       BARCELONA 
##        39.93421        42.31579        48.71930        46.68421        66.14035 
##        CÁDIZ CF           CELTA         CÓRDOBA       DEPORTIVO           EIBAR 
##              NA        52.42105        41.21053        45.23684        45.45614 
##           ELCHE        ESPANYOL          GETAFE           GIJÓN          GIRONA 
##        44.89474        44.92105        41.80000        41.42105        45.44737 
##         GRANADA          HUESCA      LAS PALMAS         LEGANÉS         LEVANTE 
##        42.86842        41.21053        53.70175        41.26316        43.56842 
##          MÁLAGA        MALLORCA         OSASUNA  RAYO VALLECANO      REAL BETIS 
##        46.07895        46.15789        40.94737        53.59649        53.07368 
##     REAL MADRID   REAL SOCIEDAD      SEVILLA FC        VALENCIA      VALLADOLID 
##        57.20175        52.43860        51.73684        48.09649        43.36842 
##      VILLARREAL 
##        46.90351



summary(Empates$`Home_Team_Possession_%`)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   21.00   45.00   52.00   51.69   59.00   81.00
summary(Victorias_casa$`Home_Team_Possession_%`)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   22.00   44.00   52.00   52.18   60.00   83.00
summary(Derrotas_casa$`Home_Team_Possession_%`)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   19.00   43.00   52.00   50.86   59.00   80.00
#Con estos datos tan similares sacamos en conclusión que la posesión no ha influido mucho en las victorias(pobre Pep)



ggplot(train,aes(Home_Team ,Home_Team_Goals_Scored)) +
  geom_bar(position = "dodge", stat = "summary", fun = "mean",
           color = 'black', fill = 'red') +
  labs(title="media de goles de cada equipo como local", x="equipos", y="goles por partido") +
  theme(plot.title=element_text(hjust = 0.5), axis.text = element_text(angle = 90, color = "darkblue"))

# media de goles por partido de cada equipo en su casa



ggplot(train,aes(Away_Team ,Away_Team_Goals_Scored)) +
  geom_bar(position = "dodge", stat = "summary", fun = "mean",
           color = 'black', fill = 'red') +
  labs(title="media de goles de cada equipo como visitante", x="equipos", y="goles por partido") +
  theme(plot.title=element_text(hjust = 0.5), axis.text = element_text(angle = 90, color = "darkblue"))

# Los equipos que más goles meten por partido, son los que más temporadas han estado en primera



# Correlación de algunas variables
pairs(train %>%
        select(Home_Team_Goals_Scored, Home_Team_On_Target_Shots, Home_Team_Total_Shots, `Home_Team_Possession_%`, `Home_Team_Pass_Success_%`, Home_Team_Corners, Home_Team_Throw_Ins, Home_Team_Fouls, Home_Team_Aerials_Won), pch = 21, bg = "black", col = "red")



hist(train$Home_Team_Goals_Scored,breaks=15, main = "Histograma de goles en casa", 
     xlab = "goles")



hist(train$Away_Team_Goals_Scored,breaks=15, main = "Histograma de goles fuera", 
     xlab = "goles")

# Se marcan más goles en casa que fuera



lm_fit <- lm(Home_Team_Goals_Scored~.-Home_Team, data=train)
summary(lm_fit)
## 
## Call:
## lm(formula = Home_Team_Goals_Scored ~ . - Home_Team, data = train)
## 
## Residuals:
##        Min         1Q     Median         3Q        Max 
## -4.052e-13 -1.160e-15 -1.000e-16  1.130e-15  3.480e-14 
## 
## Coefficients: (12 not defined because of singularities)
##                                 Estimate Std. Error    t value Pr(>|t|)    
## (Intercept)                    1.150e-10  5.625e-11  2.044e+00 0.041048 *  
## ...1                           1.510e-16  7.349e-17  2.055e+00 0.039968 *  
## Away_TeamALMERÍA               7.287e-16  2.592e-15  2.810e-01 0.778640    
## Away_TeamATHLETIC             -4.605e-15  1.493e-15 -3.085e+00 0.002063 ** 
## Away_TeamATLETICO MADRID      -3.750e-15  1.511e-15 -2.482e+00 0.013148 *  
## Away_TeamBARCELONA            -1.503e-15  1.716e-15 -8.760e-01 0.381244    
## Away_TeamCELTA                -2.346e-16  1.516e-15 -1.550e-01 0.877048    
## Away_TeamCÓRDOBA               2.938e-15  2.590e-15  1.134e+00 0.256818    
## Away_TeamDEPORTIVO            -9.851e-16  1.650e-15 -5.970e-01 0.550600    
## Away_TeamEIBAR                -1.359e-15  1.506e-15 -9.020e-01 0.367139    
## Away_TeamELCHE                 2.069e-16  2.593e-15  8.000e-02 0.936403    
## Away_TeamESPANYOL             -7.988e-16  1.482e-15 -5.390e-01 0.589906    
## Away_TeamGETAFE               -1.356e-15  1.556e-15 -8.710e-01 0.383718    
## Away_TeamGIJÓN                -1.636e-16  2.000e-15 -8.200e-02 0.934841    
## Away_TeamGIRONA                1.410e-15  1.980e-15  7.120e-01 0.476511    
## Away_TeamGRANADA               5.790e-16  1.628e-15  3.560e-01 0.722171    
## Away_TeamHUESCA                6.078e-17  2.537e-15  2.400e-02 0.980886    
## Away_TeamLAS PALMAS           -5.086e-16  1.819e-15 -2.800e-01 0.779795    
## Away_TeamLEGANÉS              -4.437e-15  1.613e-15 -2.751e+00 0.005997 ** 
## Away_TeamLEVANTE               1.681e-15  1.538e-15  1.093e+00 0.274468    
## Away_TeamMÁLAGA               -1.605e-15  1.644e-15 -9.770e-01 0.328917    
## Away_TeamMALLORCA              3.999e-16  2.556e-15  1.560e-01 0.875703    
## Away_TeamOSASUNA               1.689e-16  1.977e-15  8.500e-02 0.931927    
## Away_TeamRAYO VALLECANO       -2.834e-16  1.803e-15 -1.570e-01 0.875124    
## Away_TeamREAL BETIS            1.418e-15  1.588e-15  8.930e-01 0.372198    
## Away_TeamREAL MADRID          -6.567e-15  1.621e-15 -4.051e+00 5.28e-05 ***
## Away_TeamREAL SOCIEDAD        -6.484e-16  1.511e-15 -4.290e-01 0.667830    
## Away_TeamSEVILLA FC            7.016e-17  1.514e-15  4.600e-02 0.963044    
## Away_TeamVALENCIA             -2.210e-15  1.508e-15 -1.466e+00 0.142907    
## Away_TeamVALLADOLID            1.740e-15  1.984e-15  8.770e-01 0.380358    
## Away_TeamVILLARREAL           -1.148e-15  1.508e-15 -7.620e-01 0.446262    
## `Home_Team_Possession_%`       5.866e-17  6.998e-17  8.380e-01 0.401979    
## `Away_Team_Possession_%`              NA         NA         NA       NA    
## Home_Team_Off_Target_Shots     4.472e-16  1.157e-15  3.870e-01 0.699104    
## Home_Team_On_Target_Shots     -7.787e-16  1.157e-15 -6.730e-01 0.501134    
## Home_Team_Total_Shots         -4.398e-16  1.152e-15 -3.820e-01 0.702666    
## Home_Team_Blocked_Shots        3.852e-16  1.154e-15  3.340e-01 0.738525    
## Home_Team_Corners              3.317e-16  9.442e-17  3.512e+00 0.000453 ***
## Home_Team_Throw_Ins            8.677e-17  4.063e-17  2.136e+00 0.032824 *  
## `Home_Team_Pass_Success_%`     8.475e-17  7.603e-17  1.115e+00 0.265133    
## Home_Team_Aerials_Won         -5.296e-17  4.073e-17 -1.300e+00 0.193637    
## Home_Team_Clearances           1.003e-16  3.662e-17  2.740e+00 0.006195 ** 
## Home_Team_Fouls                8.670e-17  5.964e-17  1.454e+00 0.146188    
## Home_Team_Yellow_Cards        -7.367e-17  1.549e-16 -4.750e-01 0.634518    
## Home_Team_Second_Yellow_Cards -1.269e-15  8.858e-16 -1.433e+00 0.152134    
## Home_Team_Red_Cards           -1.075e-14  9.565e-16 -1.124e+01  < 2e-16 ***
## Away_Team_Off_Target_Shots     1.030e-15  9.973e-16  1.033e+00 0.301856    
## Away_Team_On_Target_Shots      4.665e-16  1.001e-15  4.660e-01 0.641402    
## Away_Team_Total_Shots         -8.472e-16  9.938e-16 -8.520e-01 0.394052    
## Away_Team_Blocked_Shots        9.657e-16  1.002e-15  9.640e-01 0.335233    
## Away_Team_Corners              1.313e-16  1.039e-16  1.264e+00 0.206402    
## Away_Team_Throw_Ins            1.916e-17  4.310e-17  4.440e-01 0.656779    
## `Away_Team_Pass_Success_%`    -1.313e-17  7.312e-17 -1.800e-01 0.857500    
## Away_Team_Aerials_Won         -8.572e-18  4.228e-17 -2.030e-01 0.839330    
## Away_Team_Clearances          -6.803e-18  3.273e-17 -2.080e-01 0.835353    
## Away_Team_Fouls                6.010e-17  5.844e-17  1.028e+00 0.303842    
## Away_Team_Yellow_Cards         1.795e-16  1.566e-16  1.146e+00 0.251947    
## Away_Team_Second_Yellow_Cards  8.531e-16  7.606e-16  1.122e+00 0.262148    
## Away_Team_Red_Cards            1.337e-15  9.431e-16  1.418e+00 0.156358    
## Away_Team_Goals_Scored        -1.000e+00  4.823e-16 -2.073e+15  < 2e-16 ***
## year                          -5.710e-14  2.793e-14 -2.045e+00 0.041009 *  
## resultado2                    -6.183e-16  9.637e-16 -6.420e-01 0.521185    
## resultadox                    -2.141e-16  6.805e-16 -3.150e-01 0.753066    
## goles                          1.000e+00  2.701e-16  3.702e+15  < 2e-16 ***
## total_disparos                        NA         NA         NA       NA    
## total_disparos_bloqueados             NA         NA         NA       NA    
## total_corners                         NA         NA         NA       NA    
## total_centros                         NA         NA         NA       NA    
## total_d_aereos                        NA         NA         NA       NA    
## total_despejes                        NA         NA         NA       NA    
## total_faltas                          NA         NA         NA       NA    
## total_amarillas                       NA         NA         NA       NA    
## total_rojas                           NA         NA         NA       NA    
## Home_points                           NA         NA         NA       NA    
## Away_points                           NA         NA         NA       NA    
## jornada                       -1.439e-15  7.351e-16 -1.958e+00 0.050373 .  
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 9.83e-15 on 2216 degrees of freedom
## Multiple R-squared:      1,  Adjusted R-squared:      1 
## F-statistic: 6.715e+29 on 63 and 2216 DF,  p-value: < 2.2e-16
#regfit_fwd <- leaps::regsubsets(Home_Team_Goals_Scored~., train, method="forward")
#for (metric in c("r2", "adjr2", "Cp", "bic")){plot(regfit_fwd, scale=metric)}

Variables más influyentes en los goles marcados: Centros, despejes, tarjetas rojas,


prop.table(table(Victorias_casa$Home_Team_Total_Shots > Victorias_casa$Away_Team_Total_Shots))
## 
##     FALSE      TRUE 
## 0.3001894 0.6998106
#En un 30% de las victorias de casa el equipo de casa tiró menos tiros que el de fuera



prop.table(table(Victorias_casa$Home_Team_Blocked_Shots > Victorias_casa$Away_Team_Blocked_Shots))
## 
##     FALSE      TRUE 
## 0.5246212 0.4753788
#Los tiros bloqueados no influyen mucho en el resultado del partido



prop.table(table(Derrotas_casa$Home_Team_Blocked_Shots > Derrotas_casa$Away_Team_Blocked_Shots))
## 
##    FALSE     TRUE 
## 0.437788 0.562212
#En las derrotas si vemos que el 43% de las veces bloquearon menos 



5 REGRESION

Regrsión con todas las variables

lm_goles <- lm(goles~., data = train)
summary(lm_goles)
## 
## Call:
## lm(formula = goles ~ ., data = train)
## 
## Residuals:
##        Min         1Q     Median         3Q        Max 
## -4.252e-14 -1.180e-15  1.100e-16  1.310e-15  3.978e-13 
## 
## Coefficients: (12 not defined because of singularities)
##                                 Estimate Std. Error    t value Pr(>|t|)    
## (Intercept)                   -1.037e-10  5.655e-11 -1.834e+00 0.066848 .  
## ...1                          -1.363e-16  7.388e-17 -1.846e+00 0.065091 .  
## Home_TeamALMERÍA              -9.591e-16  2.590e-15 -3.700e-01 0.711142    
## Home_TeamATHLETIC             -3.738e-16  1.497e-15 -2.500e-01 0.802835    
## Home_TeamATLETICO MADRID       3.007e-16  1.515e-15  1.990e-01 0.842660    
## Home_TeamBARCELONA            -2.144e-15  1.760e-15 -1.218e+00 0.223285    
## Home_TeamCELTA                -9.547e-16  1.542e-15 -6.190e-01 0.535914    
## Home_TeamCÓRDOBA              -2.002e-15  2.592e-15 -7.720e-01 0.439992    
## Home_TeamDEPORTIVO             7.998e-16  1.645e-15  4.860e-01 0.626772    
## Home_TeamEIBAR                -4.925e-16  1.526e-15 -3.230e-01 0.746983    
## Home_TeamELCHE                -2.960e-15  2.597e-15 -1.140e+00 0.254555    
## Home_TeamESPANYOL             -2.478e-15  1.482e-15 -1.672e+00 0.094599 .  
## Home_TeamGETAFE               -2.851e-15  1.560e-15 -1.827e+00 0.067830 .  
## Home_TeamGIJÓN                -4.155e-15  2.014e-15 -2.063e+00 0.039226 *  
## Home_TeamGIRONA               -5.397e-16  1.980e-15 -2.730e-01 0.785226    
## Home_TeamGRANADA              -9.466e-16  1.625e-15 -5.820e-01 0.560375    
## Home_TeamHUESCA                1.180e-15  2.545e-15  4.640e-01 0.642900    
## Home_TeamLAS PALMAS           -5.480e-15  1.855e-15 -2.954e+00 0.003171 ** 
## Home_TeamLEGANÉS              -1.753e-15  1.611e-15 -1.089e+00 0.276446    
## Home_TeamLEVANTE              -1.458e-15  1.546e-15 -9.430e-01 0.345638    
## Home_TeamMÁLAGA                5.077e-15  1.641e-15  3.094e+00 0.002002 ** 
## Home_TeamMALLORCA             -1.474e-15  2.555e-15 -5.770e-01 0.564009    
## Home_TeamOSASUNA              -3.709e-16  1.991e-15 -1.860e-01 0.852266    
## Home_TeamRAYO VALLECANO       -4.176e-15  1.805e-15 -2.314e+00 0.020782 *  
## Home_TeamREAL BETIS           -2.062e-15  1.598e-15 -1.290e+00 0.197184    
## Home_TeamREAL MADRID          -1.046e-15  1.673e-15 -6.250e-01 0.532040    
## Home_TeamREAL SOCIEDAD         3.737e-16  1.526e-15  2.450e-01 0.806617    
## Home_TeamSEVILLA FC           -1.665e-16  1.550e-15 -1.070e-01 0.914460    
## Home_TeamVALENCIA             -1.680e-16  1.521e-15 -1.110e-01 0.912015    
## Home_TeamVALLADOLID            1.864e-15  1.993e-15  9.350e-01 0.349727    
## Home_TeamVILLARREAL           -1.648e-15  1.522e-15 -1.083e+00 0.278961    
## Away_TeamALMERÍA               9.205e-15  2.588e-15  3.557e+00 0.000383 ***
## Away_TeamATHLETIC              3.958e-15  1.498e-15  2.642e+00 0.008308 ** 
## Away_TeamATLETICO MADRID      -8.607e-16  1.516e-15 -5.680e-01 0.570196    
## Away_TeamBARCELONA             5.579e-16  1.768e-15  3.160e-01 0.752331    
## Away_TeamCELTA                 6.818e-16  1.523e-15  4.480e-01 0.654362    
## Away_TeamCÓRDOBA               4.133e-16  2.589e-15  1.600e-01 0.873206    
## Away_TeamDEPORTIVO             1.370e-15  1.650e-15  8.310e-01 0.406202    
## Away_TeamEIBAR                 2.817e-15  1.513e-15  1.862e+00 0.062729 .  
## Away_TeamELCHE                -2.987e-15  2.589e-15 -1.154e+00 0.248629    
## Away_TeamESPANYOL              1.309e-15  1.481e-15  8.840e-01 0.376749    
## Away_TeamGETAFE                3.797e-16  1.557e-15  2.440e-01 0.807336    
## Away_TeamGIJÓN                 3.729e-16  1.996e-15  1.870e-01 0.851829    
## Away_TeamGIRONA                2.581e-16  1.978e-15  1.300e-01 0.896183    
## Away_TeamGRANADA               1.627e-15  1.625e-15  1.001e+00 0.316792    
## Away_TeamHUESCA               -5.483e-16  2.532e-15 -2.170e-01 0.828593    
## Away_TeamLAS PALMAS            4.558e-15  1.825e-15  2.497e+00 0.012588 *  
## Away_TeamLEGANÉS              -7.124e-16  1.610e-15 -4.420e-01 0.658262    
## Away_TeamLEVANTE               2.478e-15  1.536e-15  1.613e+00 0.106850    
## Away_TeamMÁLAGA               -7.302e-16  1.643e-15 -4.440e-01 0.656785    
## Away_TeamMALLORCA              4.265e-15  2.552e-15  1.671e+00 0.094851 .  
## Away_TeamOSASUNA              -9.294e-16  1.974e-15 -4.710e-01 0.637826    
## Away_TeamRAYO VALLECANO        3.447e-15  1.807e-15  1.908e+00 0.056577 .  
## Away_TeamREAL BETIS            2.295e-15  1.596e-15  1.438e+00 0.150706    
## Away_TeamREAL MADRID           2.442e-15  1.648e-15  1.482e+00 0.138554    
## Away_TeamREAL SOCIEDAD         2.615e-15  1.521e-15  1.719e+00 0.085709 .  
## Away_TeamSEVILLA FC            2.029e-15  1.521e-15  1.334e+00 0.182380    
## Away_TeamVALENCIA              2.030e-15  1.512e-15  1.343e+00 0.179491    
## Away_TeamVALLADOLID            8.160e-16  1.979e-15  4.120e-01 0.680191    
## Away_TeamVILLARREAL            2.426e-15  1.511e-15  1.606e+00 0.108421    
## `Home_Team_Possession_%`       2.661e-16  7.675e-17  3.467e+00 0.000537 ***
## `Away_Team_Possession_%`              NA         NA         NA       NA    
## Home_Team_Off_Target_Shots    -5.490e-17  1.160e-15 -4.700e-02 0.962264    
## Home_Team_On_Target_Shots      8.129e-16  1.160e-15  7.010e-01 0.483655    
## Home_Team_Total_Shots          1.966e-16  1.155e-15  1.700e-01 0.864902    
## Home_Team_Blocked_Shots       -4.294e-16  1.157e-15 -3.710e-01 0.710587    
## Home_Team_Corners             -1.787e-16  9.541e-17 -1.873e+00 0.061268 .  
## Home_Team_Throw_Ins            1.039e-16  4.171e-17  2.490e+00 0.012842 *  
## `Home_Team_Pass_Success_%`    -1.984e-16  8.174e-17 -2.428e+00 0.015282 *  
## Home_Team_Aerials_Won          1.748e-18  4.342e-17  4.000e-02 0.967898    
## Home_Team_Clearances          -7.912e-17  3.698e-17 -2.139e+00 0.032523 *  
## Home_Team_Fouls               -4.362e-17  6.077e-17 -7.180e-01 0.472930    
## Home_Team_Yellow_Cards         4.599e-17  1.560e-16  2.950e-01 0.768092    
## Home_Team_Second_Yellow_Cards  6.128e-17  8.899e-16  6.900e-02 0.945103    
## Home_Team_Red_Cards            6.101e-15  9.652e-16  6.321e+00 3.14e-10 ***
## Away_Team_Off_Target_Shots     5.597e-16  9.965e-16  5.620e-01 0.574360    
## Away_Team_On_Target_Shots      1.487e-15  1.001e-15  1.486e+00 0.137365    
## Away_Team_Total_Shots         -6.901e-16  9.931e-16 -6.950e-01 0.487226    
## Away_Team_Blocked_Shots        6.828e-16  1.001e-15  6.820e-01 0.495242    
## Away_Team_Corners             -6.942e-17  1.044e-16 -6.650e-01 0.506168    
## Away_Team_Throw_Ins            4.391e-18  4.458e-17  9.800e-02 0.921561    
## `Away_Team_Pass_Success_%`     1.144e-16  7.615e-17  1.502e+00 0.133206    
## Away_Team_Aerials_Won          2.425e-17  4.290e-17  5.650e-01 0.571987    
## Away_Team_Clearances          -2.391e-16  3.404e-17 -7.023e+00 2.90e-12 ***
## Away_Team_Fouls               -1.750e-16  6.009e-17 -2.913e+00 0.003616 ** 
## Away_Team_Yellow_Cards         1.858e-16  1.586e-16  1.171e+00 0.241533    
## Away_Team_Second_Yellow_Cards  4.049e-16  7.679e-16  5.270e-01 0.598062    
## Away_Team_Red_Cards           -3.413e-16  9.455e-16 -3.610e-01 0.718154    
## Home_Team_Goals_Scored         1.000e+00  2.730e-16  3.663e+15  < 2e-16 ***
## Away_Team_Goals_Scored         1.000e+00  3.085e-16  3.242e+15  < 2e-16 ***
## year                           5.149e-14  2.808e-14  1.834e+00 0.066819 .  
## resultado2                    -1.171e-15  9.729e-16 -1.204e+00 0.228794    
## resultadox                    -6.430e-16  6.855e-16 -9.380e-01 0.348277    
## total_disparos                        NA         NA         NA       NA    
## total_disparos_bloqueados             NA         NA         NA       NA    
## total_corners                         NA         NA         NA       NA    
## total_centros                         NA         NA         NA       NA    
## total_d_aereos                        NA         NA         NA       NA    
## total_despejes                        NA         NA         NA       NA    
## total_faltas                          NA         NA         NA       NA    
## total_amarillas                       NA         NA         NA       NA    
## total_rojas                           NA         NA         NA       NA    
## Home_points                           NA         NA         NA       NA    
## Away_points                           NA         NA         NA       NA    
## jornada                        1.324e-15  7.390e-16  1.792e+00 0.073343 .  
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 9.794e-15 on 2187 degrees of freedom
## Multiple R-squared:      1,  Adjusted R-squared:      1 
## F-statistic: 7.5e+29 on 92 and 2187 DF,  p-value: < 2.2e-16
lm_disparos <- lm(total_disparos~., data = train)
summary(lm_disparos)
## 
## Call:
## lm(formula = total_disparos ~ ., data = train)
## 
## Residuals:
##        Min         1Q     Median         3Q        Max 
## -2.785e-13 -1.070e-14  4.200e-15  1.890e-14  6.871e-12 
## 
## Coefficients: (12 not defined because of singularities)
##                                 Estimate Std. Error    t value Pr(>|t|)    
## (Intercept)                   -1.903e-09  8.797e-10 -2.164e+00  0.03061 *  
## ...1                          -2.497e-15  1.149e-15 -2.173e+00  0.02989 *  
## Home_TeamALMERÍA              -2.646e-14  4.029e-14 -6.570e-01  0.51138    
## Home_TeamATHLETIC             -2.397e-15  2.329e-14 -1.030e-01  0.91805    
## Home_TeamATLETICO MADRID      -8.469e-15  2.357e-14 -3.590e-01  0.71934    
## Home_TeamBARCELONA            -2.508e-14  2.738e-14 -9.160e-01  0.35977    
## Home_TeamCELTA                -7.377e-15  2.399e-14 -3.080e-01  0.75847    
## Home_TeamCÓRDOBA              -8.556e-16  4.032e-14 -2.100e-02  0.98307    
## Home_TeamDEPORTIVO            -4.844e-15  2.558e-14 -1.890e-01  0.84986    
## Home_TeamEIBAR                -9.743e-15  2.374e-14 -4.100e-01  0.68160    
## Home_TeamELCHE                -1.443e-14  4.040e-14 -3.570e-01  0.72109    
## Home_TeamESPANYOL             -3.681e-16  2.305e-14 -1.600e-02  0.98726    
## Home_TeamGETAFE               -1.341e-14  2.427e-14 -5.520e-01  0.58072    
## Home_TeamGIJÓN                -2.070e-14  3.133e-14 -6.610e-01  0.50891    
## Home_TeamGIRONA                1.272e-15  3.080e-14  4.100e-02  0.96707    
## Home_TeamGRANADA              -1.049e-14  2.529e-14 -4.150e-01  0.67818    
## Home_TeamHUESCA               -3.849e-15  3.960e-14 -9.700e-02  0.92257    
## Home_TeamLAS PALMAS           -5.839e-15  2.886e-14 -2.020e-01  0.83967    
## Home_TeamLEGANÉS              -1.105e-14  2.506e-14 -4.410e-01  0.65937    
## Home_TeamLEVANTE              -1.694e-14  2.405e-14 -7.040e-01  0.48142    
## Home_TeamMÁLAGA                7.941e-14  2.553e-14  3.111e+00  0.00189 ** 
## Home_TeamMALLORCA             -4.440e-18  3.974e-14  0.000e+00  0.99991    
## Home_TeamOSASUNA              -5.090e-15  3.098e-14 -1.640e-01  0.86951    
## Home_TeamRAYO VALLECANO       -1.262e-14  2.808e-14 -4.490e-01  0.65315    
## Home_TeamREAL BETIS           -3.354e-15  2.487e-14 -1.350e-01  0.89272    
## Home_TeamREAL MADRID          -1.843e-14  2.603e-14 -7.080e-01  0.47888    
## Home_TeamREAL SOCIEDAD        -3.037e-15  2.374e-14 -1.280e-01  0.89822    
## Home_TeamSEVILLA FC           -7.815e-15  2.411e-14 -3.240e-01  0.74582    
## Home_TeamVALENCIA             -5.715e-15  2.366e-14 -2.420e-01  0.80911    
## Home_TeamVALLADOLID            2.032e-15  3.100e-14  6.600e-02  0.94774    
## Home_TeamVILLARREAL           -6.956e-15  2.368e-14 -2.940e-01  0.76896    
## Away_TeamALMERÍA               1.617e-15  4.026e-14  4.000e-02  0.96797    
## Away_TeamATHLETIC              5.872e-14  2.331e-14  2.519e+00  0.01184 *  
## Away_TeamATLETICO MADRID      -1.423e-15  2.358e-14 -6.000e-02  0.95189    
## Away_TeamBARCELONA            -2.422e-14  2.750e-14 -8.810e-01  0.37858    
## Away_TeamCELTA                -7.690e-15  2.369e-14 -3.250e-01  0.74546    
## Away_TeamCÓRDOBA              -1.514e-14  4.028e-14 -3.760e-01  0.70706    
## Away_TeamDEPORTIVO            -4.149e-15  2.566e-14 -1.620e-01  0.87156    
## Away_TeamEIBAR                -6.707e-15  2.353e-14 -2.850e-01  0.77567    
## Away_TeamELCHE                -2.436e-14  4.027e-14 -6.050e-01  0.54529    
## Away_TeamESPANYOL             -5.490e-15  2.303e-14 -2.380e-01  0.81164    
## Away_TeamGETAFE               -3.163e-15  2.422e-14 -1.310e-01  0.89612    
## Away_TeamGIJÓN                 1.061e-15  3.105e-14  3.400e-02  0.97275    
## Away_TeamGIRONA               -4.658e-15  3.076e-14 -1.510e-01  0.87965    
## Away_TeamGRANADA              -6.892e-15  2.528e-14 -2.730e-01  0.78515    
## Away_TeamHUESCA               -2.759e-15  3.939e-14 -7.000e-02  0.94416    
## Away_TeamLAS PALMAS           -1.222e-14  2.839e-14 -4.300e-01  0.66691    
## Away_TeamLEGANÉS              -3.420e-15  2.505e-14 -1.370e-01  0.89143    
## Away_TeamLEVANTE              -1.425e-14  2.389e-14 -5.970e-01  0.55089    
## Away_TeamMÁLAGA               -6.897e-16  2.556e-14 -2.700e-02  0.97848    
## Away_TeamMALLORCA              2.873e-15  3.970e-14  7.200e-02  0.94231    
## Away_TeamOSASUNA               9.386e-15  3.071e-14  3.060e-01  0.75990    
## Away_TeamRAYO VALLECANO       -6.155e-15  2.811e-14 -2.190e-01  0.82669    
## Away_TeamREAL BETIS           -1.280e-14  2.483e-14 -5.160e-01  0.60616    
## Away_TeamREAL MADRID           1.362e-14  2.564e-14  5.310e-01  0.59520    
## Away_TeamREAL SOCIEDAD         2.650e-15  2.366e-14  1.120e-01  0.91084    
## Away_TeamSEVILLA FC           -6.062e-15  2.367e-14 -2.560e-01  0.79789    
## Away_TeamVALENCIA             -4.382e-15  2.352e-14 -1.860e-01  0.85224    
## Away_TeamVALLADOLID           -1.185e-14  3.079e-14 -3.850e-01  0.70048    
## Away_TeamVILLARREAL           -8.914e-15  2.350e-14 -3.790e-01  0.70449    
## `Home_Team_Possession_%`       1.559e-15  1.194e-15  1.305e+00  0.19186    
## `Away_Team_Possession_%`              NA         NA         NA       NA    
## Home_Team_Off_Target_Shots    -6.887e-16  1.805e-14 -3.800e-02  0.96957    
## Home_Team_On_Target_Shots     -3.796e-15  1.805e-14 -2.100e-01  0.83345    
## Home_Team_Total_Shots          1.000e+00  1.797e-14  5.563e+13  < 2e-16 ***
## Home_Team_Blocked_Shots       -4.680e-16  1.800e-14 -2.600e-02  0.97926    
## Home_Team_Corners             -2.029e-16  1.484e-15 -1.370e-01  0.89126    
## Home_Team_Throw_Ins           -1.111e-15  6.488e-16 -1.712e+00  0.08697 .  
## `Home_Team_Pass_Success_%`    -2.275e-15  1.272e-15 -1.789e+00  0.07375 .  
## Home_Team_Aerials_Won         -2.163e-16  6.754e-16 -3.200e-01  0.74885    
## Home_Team_Clearances          -3.969e-16  5.753e-16 -6.900e-01  0.49030    
## Home_Team_Fouls               -7.746e-16  9.454e-16 -8.190e-01  0.41270    
## Home_Team_Yellow_Cards         1.138e-15  2.426e-15  4.690e-01  0.63914    
## Home_Team_Second_Yellow_Cards  1.409e-15  1.384e-14  1.020e-01  0.91893    
## Home_Team_Red_Cards            1.360e-13  1.502e-14  9.060e+00  < 2e-16 ***
## Away_Team_Off_Target_Shots    -2.766e-15  1.550e-14 -1.780e-01  0.85839    
## Away_Team_On_Target_Shots      2.079e-15  1.557e-14  1.340e-01  0.89375    
## Away_Team_Total_Shots          1.000e+00  1.545e-14  6.473e+13  < 2e-16 ***
## Away_Team_Blocked_Shots       -8.861e-16  1.557e-14 -5.700e-02  0.95463    
## Away_Team_Corners             -5.089e-16  1.624e-15 -3.130e-01  0.75405    
## Away_Team_Throw_Ins           -2.886e-16  6.936e-16 -4.160e-01  0.67738    
## `Away_Team_Pass_Success_%`     1.269e-15  1.185e-15  1.072e+00  0.28397    
## Away_Team_Aerials_Won          7.110e-17  6.673e-16  1.070e-01  0.91516    
## Away_Team_Clearances          -4.433e-16  5.296e-16 -8.370e-01  0.40266    
## Away_Team_Fouls               -1.323e-15  9.348e-16 -1.415e+00  0.15710    
## Away_Team_Yellow_Cards         6.105e-16  2.467e-15  2.470e-01  0.80458    
## Away_Team_Second_Yellow_Cards -4.817e-15  1.194e-14 -4.030e-01  0.68682    
## Away_Team_Red_Cards           -1.416e-14  1.471e-14 -9.630e-01  0.33574    
## Home_Team_Goals_Scored        -3.459e-15  4.247e-15 -8.150e-01  0.41542    
## Away_Team_Goals_Scored        -3.047e-15  4.799e-15 -6.350e-01  0.52555    
## year                           9.451e-13  4.368e-13  2.164e+00  0.03059 *  
## resultado2                    -2.460e-14  1.514e-14 -1.626e+00  0.10420    
## resultadox                    -1.661e-14  1.066e-14 -1.557e+00  0.11951    
## goles                                 NA         NA         NA       NA    
## total_disparos_bloqueados             NA         NA         NA       NA    
## total_corners                         NA         NA         NA       NA    
## total_centros                         NA         NA         NA       NA    
## total_d_aereos                        NA         NA         NA       NA    
## total_despejes                        NA         NA         NA       NA    
## total_faltas                          NA         NA         NA       NA    
## total_amarillas                       NA         NA         NA       NA    
## total_rojas                           NA         NA         NA       NA    
## Home_points                           NA         NA         NA       NA    
## Away_points                           NA         NA         NA       NA    
## jornada                        2.442e-14  1.150e-14  2.124e+00  0.03377 *  
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 1.524e-13 on 2187 degrees of freedom
## Multiple R-squared:      1,  Adjusted R-squared:      1 
## F-statistic: 3.438e+28 on 92 and 2187 DF,  p-value: < 2.2e-16
lm_disparos_bloqueados <- lm(total_disparos_bloqueados~., data = train)
summary(lm_disparos_bloqueados)
## 
## Call:
## lm(formula = total_disparos_bloqueados ~ ., data = train)
## 
## Residuals:
##        Min         1Q     Median         3Q        Max 
## -1.926e-12 -5.730e-15 -1.550e-15  3.330e-15  4.481e-13 
## 
## Coefficients: (12 not defined because of singularities)
##                                 Estimate Std. Error    t value Pr(>|t|)    
## (Intercept)                    5.499e-10  2.534e-10  2.170e+00  0.03011 *  
## ...1                           7.215e-16  3.310e-16  2.179e+00  0.02941 *  
## Home_TeamALMERÍA               5.015e-16  1.160e-14  4.300e-02  0.96553    
## Home_TeamATHLETIC              2.654e-15  6.708e-15  3.960e-01  0.69242    
## Home_TeamATLETICO MADRID       3.393e-15  6.788e-15  5.000e-01  0.61728    
## Home_TeamBARCELONA             6.123e-15  7.888e-15  7.760e-01  0.43764    
## Home_TeamCELTA                 4.945e-15  6.910e-15  7.160e-01  0.47433    
## Home_TeamCÓRDOBA               2.290e-15  1.161e-14  1.970e-01  0.84369    
## Home_TeamDEPORTIVO             4.009e-15  7.369e-15  5.440e-01  0.58653    
## Home_TeamEIBAR                 7.048e-15  6.839e-15  1.030e+00  0.30290    
## Home_TeamELCHE                 5.040e-15  1.164e-14  4.330e-01  0.66503    
## Home_TeamESPANYOL              4.324e-15  6.641e-15  6.510e-01  0.51498    
## Home_TeamGETAFE                5.901e-15  6.991e-15  8.440e-01  0.39876    
## Home_TeamGIJÓN                 6.560e-15  9.024e-15  7.270e-01  0.46730    
## Home_TeamGIRONA                3.139e-15  8.873e-15  3.540e-01  0.72357    
## Home_TeamGRANADA               4.713e-15  7.284e-15  6.470e-01  0.51770    
## Home_TeamHUESCA                3.025e-15  1.141e-14  2.650e-01  0.79088    
## Home_TeamLAS PALMAS            2.301e-16  8.312e-15  2.800e-02  0.97792    
## Home_TeamLEGANÉS               1.148e-14  7.218e-15  1.590e+00  0.11201    
## Home_TeamLEVANTE               7.010e-15  6.928e-15  1.012e+00  0.31173    
## Home_TeamMÁLAGA               -1.792e-14  7.354e-15 -2.436e+00  0.01492 *  
## Home_TeamMALLORCA              4.449e-15  1.145e-14  3.890e-01  0.69763    
## Home_TeamOSASUNA               4.948e-15  8.923e-15  5.550e-01  0.57929    
## Home_TeamRAYO VALLECANO        7.925e-15  8.088e-15  9.800e-01  0.32728    
## Home_TeamREAL BETIS            7.033e-15  7.163e-15  9.820e-01  0.32628    
## Home_TeamREAL MADRID           9.773e-15  7.498e-15  1.303e+00  0.19256    
## Home_TeamREAL SOCIEDAD         4.661e-15  6.839e-15  6.820e-01  0.49561    
## Home_TeamSEVILLA FC            3.988e-15  6.944e-15  5.740e-01  0.56583    
## Home_TeamVALENCIA              2.810e-15  6.814e-15  4.120e-01  0.68012    
## Home_TeamVALLADOLID           -1.200e-15  8.930e-15 -1.340e-01  0.89313    
## Home_TeamVILLARREAL            5.904e-15  6.821e-15  8.660e-01  0.38684    
## Away_TeamALMERÍA               1.064e-15  1.160e-14  9.200e-02  0.92693    
## Away_TeamATHLETIC             -1.929e-14  6.714e-15 -2.873e+00  0.00411 ** 
## Away_TeamATLETICO MADRID      -1.581e-15  6.792e-15 -2.330e-01  0.81600    
## Away_TeamBARCELONA             2.014e-15  7.921e-15  2.540e-01  0.79926    
## Away_TeamCELTA                -1.616e-15  6.823e-15 -2.370e-01  0.81281    
## Away_TeamCÓRDOBA               4.536e-15  1.160e-14  3.910e-01  0.69588    
## Away_TeamDEPORTIVO            -1.852e-15  7.392e-15 -2.510e-01  0.80218    
## Away_TeamEIBAR                -7.241e-15  6.779e-15 -1.068e+00  0.28553    
## Away_TeamELCHE                 4.637e-16  1.160e-14  4.000e-02  0.96811    
## Away_TeamESPANYOL             -2.852e-15  6.635e-15 -4.300e-01  0.66732    
## Away_TeamGETAFE               -5.203e-15  6.977e-15 -7.460e-01  0.45591    
## Away_TeamGIJÓN                -1.265e-15  8.944e-15 -1.410e-01  0.88757    
## Away_TeamGIRONA               -2.007e-15  8.861e-15 -2.260e-01  0.82084    
## Away_TeamGRANADA               1.555e-17  7.282e-15  2.000e-03  0.99830    
## Away_TeamHUESCA               -5.168e-15  1.135e-14 -4.550e-01  0.64884    
## Away_TeamLAS PALMAS           -3.735e-16  8.179e-15 -4.600e-02  0.96358    
## Away_TeamLEGANÉS              -4.141e-15  7.216e-15 -5.740e-01  0.56612    
## Away_TeamLEVANTE               2.750e-16  6.883e-15  4.000e-02  0.96813    
## Away_TeamMÁLAGA               -3.472e-15  7.363e-15 -4.720e-01  0.63732    
## Away_TeamMALLORCA             -4.206e-15  1.144e-14 -3.680e-01  0.71303    
## Away_TeamOSASUNA              -4.316e-15  8.845e-15 -4.880e-01  0.62562    
## Away_TeamRAYO VALLECANO       -7.268e-16  8.097e-15 -9.000e-02  0.92849    
## Away_TeamREAL BETIS            3.179e-15  7.153e-15  4.440e-01  0.65674    
## Away_TeamREAL MADRID          -1.064e-15  7.385e-15 -1.440e-01  0.88544    
## Away_TeamREAL SOCIEDAD        -3.482e-15  6.815e-15 -5.110e-01  0.60947    
## Away_TeamSEVILLA FC            1.255e-15  6.818e-15  1.840e-01  0.85396    
## Away_TeamVALENCIA              1.025e-15  6.776e-15  1.510e-01  0.87973    
## Away_TeamVALLADOLID            2.010e-15  8.870e-15  2.270e-01  0.82078    
## Away_TeamVILLARREAL            8.887e-16  6.770e-15  1.310e-01  0.89557    
## `Home_Team_Possession_%`      -2.463e-16  3.439e-16 -7.160e-01  0.47390    
## `Away_Team_Possession_%`              NA         NA         NA       NA    
## Home_Team_Off_Target_Shots     7.212e-15  5.199e-15  1.387e+00  0.16556    
## Home_Team_On_Target_Shots      7.502e-15  5.200e-15  1.443e+00  0.14927    
## Home_Team_Total_Shots         -7.080e-15  5.178e-15 -1.367e+00  0.17163    
## Home_Team_Blocked_Shots        1.000e+00  5.185e-15  1.929e+14  < 2e-16 ***
## Home_Team_Corners             -2.459e-16  4.275e-16 -5.750e-01  0.56522    
## Home_Team_Throw_Ins            3.361e-16  1.869e-16  1.799e+00  0.07221 .  
## `Home_Team_Pass_Success_%`     4.790e-16  3.663e-16  1.308e+00  0.19114    
## Home_Team_Aerials_Won          1.835e-18  1.946e-16  9.000e-03  0.99248    
## Home_Team_Clearances           5.415e-17  1.657e-16  3.270e-01  0.74392    
## Home_Team_Fouls                1.160e-16  2.723e-16  4.260e-01  0.67029    
## Home_Team_Yellow_Cards        -1.610e-16  6.989e-16 -2.300e-01  0.81787    
## Home_Team_Second_Yellow_Cards -5.309e-17  3.988e-15 -1.300e-02  0.98938    
## Home_Team_Red_Cards           -3.914e-14  4.325e-15 -9.048e+00  < 2e-16 ***
## Away_Team_Off_Target_Shots    -2.100e-15  4.465e-15 -4.700e-01  0.63823    
## Away_Team_On_Target_Shots     -2.781e-15  4.484e-15 -6.200e-01  0.53512    
## Away_Team_Total_Shots          2.332e-15  4.450e-15  5.240e-01  0.60025    
## Away_Team_Blocked_Shots        1.000e+00  4.486e-15  2.229e+14  < 2e-16 ***
## Away_Team_Corners              1.212e-16  4.679e-16  2.590e-01  0.79564    
## Away_Team_Throw_Ins           -2.279e-17  1.998e-16 -1.140e-01  0.90918    
## `Away_Team_Pass_Success_%`    -3.832e-16  3.412e-16 -1.123e+00  0.26157    
## Away_Team_Aerials_Won         -9.635e-18  1.922e-16 -5.000e-02  0.96003    
## Away_Team_Clearances           1.675e-16  1.525e-16  1.098e+00  0.27242    
## Away_Team_Fouls                4.707e-16  2.693e-16  1.748e+00  0.08058 .  
## Away_Team_Yellow_Cards        -4.989e-16  7.106e-16 -7.020e-01  0.48271    
## Away_Team_Second_Yellow_Cards  1.377e-15  3.441e-15  4.000e-01  0.68902    
## Away_Team_Red_Cards            3.133e-15  4.237e-15  7.390e-01  0.45971    
## Home_Team_Goals_Scored         1.216e-15  1.223e-15  9.940e-01  0.32044    
## Away_Team_Goals_Scored         1.202e-15  1.382e-15  8.700e-01  0.38464    
## year                          -2.731e-13  1.258e-13 -2.170e+00  0.03009 *  
## resultado2                     6.006e-15  4.360e-15  1.378e+00  0.16850    
## resultadox                     5.268e-15  3.072e-15  1.715e+00  0.08650 .  
## goles                                 NA         NA         NA       NA    
## total_disparos                        NA         NA         NA       NA    
## total_corners                         NA         NA         NA       NA    
## total_centros                         NA         NA         NA       NA    
## total_d_aereos                        NA         NA         NA       NA    
## total_despejes                        NA         NA         NA       NA    
## total_faltas                          NA         NA         NA       NA    
## total_amarillas                       NA         NA         NA       NA    
## total_rojas                           NA         NA         NA       NA    
## Home_points                           NA         NA         NA       NA    
## Away_points                           NA         NA         NA       NA    
## jornada                       -7.076e-15  3.311e-15 -2.137e+00  0.03272 *  
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 4.389e-14 on 2187 degrees of freedom
## Multiple R-squared:      1,  Adjusted R-squared:      1 
## F-statistic: 8.752e+28 on 92 and 2187 DF,  p-value: < 2.2e-16
lm_corners <- lm(total_corners~., data = train)
summary(lm_corners)
## 
## Call:
## lm(formula = total_corners ~ ., data = train)
## 
## Residuals:
##        Min         1Q     Median         3Q        Max 
## -3.206e-12 -9.000e-15 -2.200e-15  5.200e-15  2.392e-13 
## 
## Coefficients: (12 not defined because of singularities)
##                                 Estimate Std. Error    t value Pr(>|t|)    
## (Intercept)                    9.505e-10  4.120e-10  2.307e+00  0.02115 *  
## ...1                           1.248e-15  5.383e-16  2.319e+00  0.02048 *  
## Home_TeamALMERÍA               1.194e-15  1.887e-14  6.300e-02  0.94957    
## Home_TeamATHLETIC              1.213e-15  1.091e-14  1.110e-01  0.91149    
## Home_TeamATLETICO MADRID       2.922e-15  1.104e-14  2.650e-01  0.79120    
## Home_TeamBARCELONA             9.535e-15  1.282e-14  7.430e-01  0.45728    
## Home_TeamCELTA                 4.547e-15  1.123e-14  4.050e-01  0.68574    
## Home_TeamCÓRDOBA              -2.775e-16  1.888e-14 -1.500e-02  0.98828    
## Home_TeamDEPORTIVO             6.664e-16  1.198e-14  5.600e-02  0.95565    
## Home_TeamEIBAR                 3.006e-15  1.112e-14  2.700e-01  0.78697    
## Home_TeamELCHE                 2.951e-15  1.892e-14  1.560e-01  0.87609    
## Home_TeamESPANYOL              1.359e-15  1.080e-14  1.260e-01  0.89987    
## Home_TeamGETAFE                9.281e-15  1.137e-14  8.160e-01  0.41431    
## Home_TeamGIJÓN                 5.420e-15  1.467e-14  3.690e-01  0.71187    
## Home_TeamGIRONA               -2.779e-15  1.443e-14 -1.930e-01  0.84727    
## Home_TeamGRANADA               3.610e-15  1.184e-14  3.050e-01  0.76053    
## Home_TeamHUESCA               -5.105e-15  1.855e-14 -2.750e-01  0.78314    
## Home_TeamLAS PALMAS            6.283e-16  1.352e-14  4.600e-02  0.96293    
## Home_TeamLEGANÉS               2.634e-15  1.174e-14  2.240e-01  0.82242    
## Home_TeamLEVANTE               6.078e-15  1.126e-14  5.400e-01  0.58954    
## Home_TeamMÁLAGA               -3.625e-14  1.196e-14 -3.032e+00  0.00246 ** 
## Home_TeamMALLORCA              5.773e-15  1.861e-14  3.100e-01  0.75649    
## Home_TeamOSASUNA               2.648e-15  1.451e-14  1.820e-01  0.85521    
## Home_TeamRAYO VALLECANO        5.360e-15  1.315e-14  4.080e-01  0.68365    
## Home_TeamREAL BETIS            3.260e-15  1.165e-14  2.800e-01  0.77955    
## Home_TeamREAL MADRID           4.905e-15  1.219e-14  4.020e-01  0.68743    
## Home_TeamREAL SOCIEDAD         1.815e-15  1.112e-14  1.630e-01  0.87036    
## Home_TeamSEVILLA FC            3.926e-15  1.129e-14  3.480e-01  0.72803    
## Home_TeamVALENCIA              9.348e-16  1.108e-14  8.400e-02  0.93276    
## Home_TeamVALLADOLID           -4.173e-15  1.452e-14 -2.870e-01  0.77384    
## Home_TeamVILLARREAL            4.499e-15  1.109e-14  4.060e-01  0.68500    
## Away_TeamALMERÍA               1.049e-14  1.885e-14  5.560e-01  0.57813    
## Away_TeamATHLETIC             -2.360e-14  1.092e-14 -2.162e+00  0.03074 *  
## Away_TeamATLETICO MADRID       1.437e-15  1.104e-14  1.300e-01  0.89649    
## Away_TeamBARCELONA             9.250e-15  1.288e-14  7.180e-01  0.47269    
## Away_TeamCELTA                 1.482e-14  1.109e-14  1.336e+00  0.18158    
## Away_TeamCÓRDOBA               3.929e-15  1.886e-14  2.080e-01  0.83506    
## Away_TeamDEPORTIVO             8.113e-15  1.202e-14  6.750e-01  0.49973    
## Away_TeamEIBAR                 3.268e-15  1.102e-14  2.970e-01  0.76687    
## Away_TeamELCHE                 1.217e-14  1.886e-14  6.450e-01  0.51880    
## Away_TeamESPANYOL              2.738e-15  1.079e-14  2.540e-01  0.79967    
## Away_TeamGETAFE                2.524e-15  1.134e-14  2.230e-01  0.82393    
## Away_TeamGIJÓN                 8.525e-16  1.454e-14  5.900e-02  0.95326    
## Away_TeamGIRONA                4.338e-15  1.441e-14  3.010e-01  0.76338    
## Away_TeamGRANADA               2.116e-15  1.184e-14  1.790e-01  0.85820    
## Away_TeamHUESCA               -7.336e-15  1.845e-14 -3.980e-01  0.69096    
## Away_TeamLAS PALMAS            7.845e-15  1.330e-14  5.900e-01  0.55530    
## Away_TeamLEGANÉS              -1.421e-15  1.173e-14 -1.210e-01  0.90359    
## Away_TeamLEVANTE               2.940e-15  1.119e-14  2.630e-01  0.79276    
## Away_TeamMÁLAGA                3.987e-15  1.197e-14  3.330e-01  0.73909    
## Away_TeamMALLORCA             -1.262e-15  1.859e-14 -6.800e-02  0.94587    
## Away_TeamOSASUNA              -4.229e-16  1.438e-14 -2.900e-02  0.97654    
## Away_TeamRAYO VALLECANO        9.250e-15  1.317e-14  7.030e-01  0.48236    
## Away_TeamREAL BETIS            1.141e-14  1.163e-14  9.810e-01  0.32673    
## Away_TeamREAL MADRID           2.422e-16  1.201e-14  2.000e-02  0.98391    
## Away_TeamREAL SOCIEDAD         2.158e-15  1.108e-14  1.950e-01  0.84559    
## Away_TeamSEVILLA FC            4.373e-15  1.109e-14  3.940e-01  0.69329    
## Away_TeamVALENCIA              3.403e-15  1.102e-14  3.090e-01  0.75740    
## Away_TeamVALLADOLID            4.521e-15  1.442e-14  3.140e-01  0.75391    
## Away_TeamVILLARREAL            2.991e-15  1.101e-14  2.720e-01  0.78586    
## `Home_Team_Possession_%`      -6.413e-16  5.592e-16 -1.147e+00  0.25159    
## `Away_Team_Possession_%`              NA         NA         NA       NA    
## Home_Team_Off_Target_Shots    -1.440e-15  8.454e-15 -1.700e-01  0.86474    
## Home_Team_On_Target_Shots     -1.418e-15  8.455e-15 -1.680e-01  0.86683    
## Home_Team_Total_Shots          2.014e-15  8.419e-15  2.390e-01  0.81092    
## Home_Team_Blocked_Shots       -2.676e-15  8.430e-15 -3.170e-01  0.75092    
## Home_Team_Corners              1.000e+00  6.952e-16  1.439e+15  < 2e-16 ***
## Home_Team_Throw_Ins            4.072e-16  3.039e-16  1.340e+00  0.18040    
## `Home_Team_Pass_Success_%`     1.103e-15  5.956e-16  1.853e+00  0.06405 .  
## Home_Team_Aerials_Won          5.643e-17  3.163e-16  1.780e-01  0.85845    
## Home_Team_Clearances           6.460e-16  2.695e-16  2.397e+00  0.01659 *  
## Home_Team_Fouls                3.775e-16  4.428e-16  8.530e-01  0.39402    
## Home_Team_Yellow_Cards        -4.951e-16  1.136e-15 -4.360e-01  0.66312    
## Home_Team_Second_Yellow_Cards -9.614e-17  6.484e-15 -1.500e-02  0.98817    
## Home_Team_Red_Cards           -6.173e-14  7.032e-15 -8.777e+00  < 2e-16 ***
## Away_Team_Off_Target_Shots     1.508e-15  7.260e-15  2.080e-01  0.83547    
## Away_Team_On_Target_Shots      7.650e-16  7.291e-15  1.050e-01  0.91644    
## Away_Team_Total_Shots         -8.852e-16  7.236e-15 -1.220e-01  0.90264    
## Away_Team_Blocked_Shots        1.946e-15  7.293e-15  2.670e-01  0.78963    
## Away_Team_Corners              1.000e+00  7.607e-16  1.315e+15  < 2e-16 ***
## Away_Team_Throw_Ins            2.144e-16  3.248e-16  6.600e-01  0.50925    
## `Away_Team_Pass_Success_%`    -6.097e-16  5.548e-16 -1.099e+00  0.27188    
## Away_Team_Aerials_Won         -8.847e-17  3.125e-16 -2.830e-01  0.77715    
## Away_Team_Clearances           1.831e-16  2.480e-16  7.380e-01  0.46055    
## Away_Team_Fouls                6.692e-16  4.378e-16  1.528e+00  0.12655    
## Away_Team_Yellow_Cards        -3.324e-16  1.155e-15 -2.880e-01  0.77359    
## Away_Team_Second_Yellow_Cards  5.051e-16  5.595e-15  9.000e-02  0.92807    
## Away_Team_Red_Cards            6.042e-15  6.889e-15  8.770e-01  0.38057    
## Home_Team_Goals_Scored         1.400e-15  1.989e-15  7.040e-01  0.48168    
## Away_Team_Goals_Scored         1.466e-15  2.248e-15  6.520e-01  0.51418    
## year                          -4.720e-13  2.046e-13 -2.307e+00  0.02113 *  
## resultado2                     1.084e-14  7.089e-15  1.529e+00  0.12639    
## resultadox                     7.419e-15  4.994e-15  1.486e+00  0.13754    
## goles                                 NA         NA         NA       NA    
## total_disparos                        NA         NA         NA       NA    
## total_disparos_bloqueados             NA         NA         NA       NA    
## total_centros                         NA         NA         NA       NA    
## total_d_aereos                        NA         NA         NA       NA    
## total_despejes                        NA         NA         NA       NA    
## total_faltas                          NA         NA         NA       NA    
## total_amarillas                       NA         NA         NA       NA    
## total_rojas                           NA         NA         NA       NA    
## Home_points                           NA         NA         NA       NA    
## Away_points                           NA         NA         NA       NA    
## jornada                       -1.220e-14  5.384e-15 -2.267e+00  0.02351 *  
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 7.136e-14 on 2187 degrees of freedom
## Multiple R-squared:      1,  Adjusted R-squared:      1 
## F-statistic: 5.553e+28 on 92 and 2187 DF,  p-value: < 2.2e-16
lm_centros <- lm(total_centros~., data = train)
summary(lm_centros)
## 
## Call:
## lm(formula = total_centros ~ ., data = train)
## 
## Residuals:
##        Min         1Q     Median         3Q        Max 
## -4.561e-12 -1.320e-14 -2.500e-15  8.600e-15  6.560e-13 
## 
## Coefficients: (12 not defined because of singularities)
##                                 Estimate Std. Error    t value Pr(>|t|)    
## (Intercept)                    1.279e-09  5.956e-10  2.148e+00 0.031834 *  
## ...1                           1.683e-15  7.781e-16  2.163e+00 0.030613 *  
## Home_TeamALMERÍA               8.982e-15  2.727e-14  3.290e-01 0.741949    
## Home_TeamATHLETIC              9.438e-15  1.577e-14  5.990e-01 0.549515    
## Home_TeamATLETICO MADRID       2.146e-15  1.595e-14  1.350e-01 0.893004    
## Home_TeamBARCELONA             3.341e-14  1.854e-14  1.802e+00 0.071659 .  
## Home_TeamCELTA                 1.445e-14  1.624e-14  8.900e-01 0.373674    
## Home_TeamCÓRDOBA               2.248e-14  2.729e-14  8.240e-01 0.410206    
## Home_TeamDEPORTIVO             2.687e-15  1.732e-14  1.550e-01 0.876724    
## Home_TeamEIBAR                 5.974e-15  1.608e-14  3.720e-01 0.710198    
## Home_TeamELCHE                 1.171e-14  2.736e-14  4.280e-01 0.668734    
## Home_TeamESPANYOL             -1.293e-15  1.561e-14 -8.300e-02 0.933969    
## Home_TeamGETAFE               -5.727e-15  1.643e-14 -3.490e-01 0.727463    
## Home_TeamGIJÓN                 1.327e-14  2.121e-14  6.260e-01 0.531656    
## Home_TeamGIRONA               -2.835e-15  2.086e-14 -1.360e-01 0.891882    
## Home_TeamGRANADA              -1.696e-14  1.712e-14 -9.910e-01 0.321934    
## Home_TeamHUESCA               -2.742e-15  2.681e-14 -1.020e-01 0.918554    
## Home_TeamLAS PALMAS            3.309e-15  1.954e-14  1.690e-01 0.865528    
## Home_TeamLEGANÉS               1.003e-14  1.696e-14  5.910e-01 0.554605    
## Home_TeamLEVANTE               9.695e-15  1.628e-14  5.950e-01 0.551632    
## Home_TeamMÁLAGA               -5.999e-14  1.728e-14 -3.471e+00 0.000529 ***
## Home_TeamMALLORCA             -9.780e-15  2.691e-14 -3.630e-01 0.716291    
## Home_TeamOSASUNA              -2.108e-14  2.097e-14 -1.005e+00 0.315058    
## Home_TeamRAYO VALLECANO        1.802e-14  1.901e-14  9.480e-01 0.343302    
## Home_TeamREAL BETIS            3.281e-15  1.683e-14  1.950e-01 0.845468    
## Home_TeamREAL MADRID           1.358e-14  1.762e-14  7.710e-01 0.440945    
## Home_TeamREAL SOCIEDAD         2.423e-15  1.608e-14  1.510e-01 0.880186    
## Home_TeamSEVILLA FC           -2.065e-15  1.632e-14 -1.270e-01 0.899333    
## Home_TeamVALENCIA              4.557e-15  1.602e-14  2.850e-01 0.776040    
## Home_TeamVALLADOLID           -1.345e-15  2.099e-14 -6.400e-02 0.948904    
## Home_TeamVILLARREAL            4.258e-16  1.603e-14  2.700e-02 0.978814    
## Away_TeamALMERÍA               1.862e-14  2.726e-14  6.830e-01 0.494639    
## Away_TeamATHLETIC             -3.856e-14  1.578e-14 -2.443e+00 0.014631 *  
## Away_TeamATLETICO MADRID       5.965e-15  1.596e-14  3.740e-01 0.708710    
## Away_TeamBARCELONA             1.505e-14  1.862e-14  8.080e-01 0.418978    
## Away_TeamCELTA                 3.889e-15  1.604e-14  2.420e-01 0.808426    
## Away_TeamCÓRDOBA               5.232e-16  2.727e-14  1.900e-02 0.984694    
## Away_TeamDEPORTIVO            -7.569e-16  1.737e-14 -4.400e-02 0.965254    
## Away_TeamEIBAR                 1.049e-14  1.593e-14  6.580e-01 0.510297    
## Away_TeamELCHE                 5.249e-15  2.726e-14  1.930e-01 0.847349    
## Away_TeamESPANYOL             -6.853e-15  1.560e-14 -4.390e-01 0.660373    
## Away_TeamGETAFE               -1.629e-15  1.640e-14 -9.900e-02 0.920886    
## Away_TeamGIJÓN                -1.627e-14  2.102e-14 -7.740e-01 0.438976    
## Away_TeamGIRONA                2.354e-15  2.083e-14  1.130e-01 0.910012    
## Away_TeamGRANADA               1.501e-14  1.711e-14  8.770e-01 0.380618    
## Away_TeamHUESCA               -1.746e-14  2.667e-14 -6.550e-01 0.512827    
## Away_TeamLAS PALMAS            5.988e-15  1.922e-14  3.120e-01 0.755447    
## Away_TeamLEGANÉS              -4.083e-15  1.696e-14 -2.410e-01 0.809794    
## Away_TeamLEVANTE              -3.903e-15  1.618e-14 -2.410e-01 0.809368    
## Away_TeamMÁLAGA               -8.357e-15  1.730e-14 -4.830e-01 0.629207    
## Away_TeamMALLORCA             -1.423e-14  2.688e-14 -5.290e-01 0.596595    
## Away_TeamOSASUNA              -7.924e-15  2.079e-14 -3.810e-01 0.703136    
## Away_TeamRAYO VALLECANO        1.511e-15  1.903e-14  7.900e-02 0.936720    
## Away_TeamREAL BETIS            3.906e-15  1.681e-14  2.320e-01 0.816304    
## Away_TeamREAL MADRID          -1.719e-15  1.736e-14 -9.900e-02 0.921138    
## Away_TeamREAL SOCIEDAD        -1.146e-14  1.602e-14 -7.150e-01 0.474391    
## Away_TeamSEVILLA FC           -8.318e-15  1.602e-14 -5.190e-01 0.603735    
## Away_TeamVALENCIA             -1.018e-15  1.592e-14 -6.400e-02 0.949042    
## Away_TeamVALLADOLID           -5.975e-15  2.085e-14 -2.870e-01 0.774433    
## Away_TeamVILLARREAL           -9.953e-15  1.591e-14 -6.260e-01 0.531667    
## `Home_Team_Possession_%`      -1.568e-15  8.083e-16 -1.940e+00 0.052567 .  
## `Away_Team_Possession_%`              NA         NA         NA       NA    
## Home_Team_Off_Target_Shots     5.660e-16  1.222e-14  4.600e-02 0.963061    
## Home_Team_On_Target_Shots      2.278e-15  1.222e-14  1.860e-01 0.852185    
## Home_Team_Total_Shots          7.931e-17  1.217e-14  7.000e-03 0.994801    
## Home_Team_Blocked_Shots       -1.246e-15  1.219e-14 -1.020e-01 0.918603    
## Home_Team_Corners             -4.752e-16  1.005e-15 -4.730e-01 0.636339    
## Home_Team_Throw_Ins            1.000e+00  4.392e-16  2.277e+15  < 2e-16 ***
## `Home_Team_Pass_Success_%`     2.516e-15  8.609e-16  2.923e+00 0.003506 ** 
## Home_Team_Aerials_Won          4.588e-17  4.573e-16  1.000e-01 0.920087    
## Home_Team_Clearances          -1.845e-16  3.895e-16 -4.740e-01 0.635808    
## Home_Team_Fouls                1.052e-15  6.400e-16  1.643e+00 0.100524    
## Home_Team_Yellow_Cards        -2.302e-16  1.643e-15 -1.400e-01 0.888567    
## Home_Team_Second_Yellow_Cards  1.835e-15  9.372e-15  1.960e-01 0.844780    
## Home_Team_Red_Cards           -8.440e-14  1.017e-14 -8.303e+00  < 2e-16 ***
## Away_Team_Off_Target_Shots     2.376e-15  1.049e-14  2.260e-01 0.820881    
## Away_Team_On_Target_Shots     -4.387e-16  1.054e-14 -4.200e-02 0.966799    
## Away_Team_Total_Shots         -6.522e-16  1.046e-14 -6.200e-02 0.950288    
## Away_Team_Blocked_Shots        1.204e-15  1.054e-14  1.140e-01 0.909067    
## Away_Team_Corners              1.681e-15  1.100e-15  1.529e+00 0.126525    
## Away_Team_Throw_Ins            1.000e+00  4.696e-16  2.130e+15  < 2e-16 ***
## `Away_Team_Pass_Success_%`    -6.680e-16  8.020e-16 -8.330e-01 0.405003    
## Away_Team_Aerials_Won         -1.403e-16  4.518e-16 -3.110e-01 0.756199    
## Away_Team_Clearances           3.342e-16  3.585e-16  9.320e-01 0.351382    
## Away_Team_Fouls                9.319e-16  6.329e-16  1.472e+00 0.141063    
## Away_Team_Yellow_Cards        -6.374e-16  1.670e-15 -3.820e-01 0.702764    
## Away_Team_Second_Yellow_Cards  3.181e-15  8.087e-15  3.930e-01 0.694108    
## Away_Team_Red_Cards            1.157e-14  9.958e-15  1.161e+00 0.245595    
## Home_Team_Goals_Scored         2.836e-15  2.875e-15  9.860e-01 0.324029    
## Away_Team_Goals_Scored         1.630e-15  3.249e-15  5.020e-01 0.615961    
## year                          -6.354e-13  2.957e-13 -2.148e+00 0.031785 *  
## resultado2                     1.861e-14  1.025e-14  1.816e+00 0.069551 .  
## resultadox                     1.171e-14  7.219e-15  1.622e+00 0.104898    
## goles                                 NA         NA         NA       NA    
## total_disparos                        NA         NA         NA       NA    
## total_disparos_bloqueados             NA         NA         NA       NA    
## total_corners                         NA         NA         NA       NA    
## total_d_aereos                        NA         NA         NA       NA    
## total_despejes                        NA         NA         NA       NA    
## total_faltas                          NA         NA         NA       NA    
## total_amarillas                       NA         NA         NA       NA    
## total_rojas                           NA         NA         NA       NA    
## Home_points                           NA         NA         NA       NA    
## Away_points                           NA         NA         NA       NA    
## jornada                       -1.638e-14  7.783e-15 -2.104e+00 0.035454 *  
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 1.032e-13 on 2187 degrees of freedom
## Multiple R-squared:      1,  Adjusted R-squared:      1 
## F-statistic: 2.616e+29 on 92 and 2187 DF,  p-value: < 2.2e-16
lm_d_aereos <- lm(total_d_aereos~., data = train)
summary(lm_d_aereos)
## 
## Call:
## lm(formula = total_d_aereos ~ ., data = train)
## 
## Residuals:
##        Min         1Q     Median         3Q        Max 
## -1.409e-12 -6.110e-15 -6.600e-16  5.370e-15  6.267e-13 
## 
## Coefficients: (12 not defined because of singularities)
##                                 Estimate Std. Error    t value Pr(>|t|)    
## (Intercept)                    1.964e-10  2.266e-10  8.670e-01 0.386164    
## ...1                           2.661e-16  2.961e-16  8.990e-01 0.368910    
## Home_TeamALMERÍA               4.345e-15  1.038e-14  4.190e-01 0.675488    
## Home_TeamATHLETIC              2.631e-14  6.000e-15  4.386e+00 1.21e-05 ***
## Home_TeamATLETICO MADRID       1.676e-14  6.071e-15  2.761e+00 0.005812 ** 
## Home_TeamBARCELONA            -2.925e-14  7.055e-15 -4.146e+00 3.51e-05 ***
## Home_TeamCELTA                 1.686e-14  6.180e-15  2.727e+00 0.006435 ** 
## Home_TeamCÓRDOBA               2.973e-14  1.039e-14  2.862e+00 0.004251 ** 
## Home_TeamDEPORTIVO             1.695e-14  6.591e-15  2.571e+00 0.010196 *  
## Home_TeamEIBAR                -9.792e-15  6.117e-15 -1.601e+00 0.109595    
## Home_TeamELCHE                 1.849e-14  1.041e-14  1.776e+00 0.075824 .  
## Home_TeamESPANYOL              2.433e-14  5.939e-15  4.096e+00 4.36e-05 ***
## Home_TeamGETAFE                2.789e-15  6.253e-15  4.460e-01 0.655656    
## Home_TeamGIJÓN                 2.944e-15  8.071e-15  3.650e-01 0.715323    
## Home_TeamGIRONA                4.519e-15  7.936e-15  5.690e-01 0.569145    
## Home_TeamGRANADA               8.437e-15  6.515e-15  1.295e+00 0.195435    
## Home_TeamHUESCA                1.931e-14  1.020e-14  1.893e+00 0.058449 .  
## Home_TeamLAS PALMAS            2.714e-14  7.434e-15  3.650e+00 0.000268 ***
## Home_TeamLEGANÉS               1.616e-14  6.456e-15  2.503e+00 0.012378 *  
## Home_TeamLEVANTE               7.478e-15  6.196e-15  1.207e+00 0.227626    
## Home_TeamMÁLAGA               -3.570e-15  6.577e-15 -5.430e-01 0.587304    
## Home_TeamMALLORCA              2.996e-14  1.024e-14  2.926e+00 0.003470 ** 
## Home_TeamOSASUNA              -2.142e-14  7.981e-15 -2.684e+00 0.007322 ** 
## Home_TeamRAYO VALLECANO        1.318e-14  7.234e-15  1.822e+00 0.068565 .  
## Home_TeamREAL BETIS            7.066e-15  6.406e-15  1.103e+00 0.270145    
## Home_TeamREAL MADRID           2.102e-14  6.706e-15  3.135e+00 0.001744 ** 
## Home_TeamREAL SOCIEDAD         1.722e-14  6.117e-15  2.814e+00 0.004933 ** 
## Home_TeamSEVILLA FC            1.184e-14  6.210e-15  1.906e+00 0.056764 .  
## Home_TeamVALENCIA              1.186e-14  6.094e-15  1.947e+00 0.051715 .  
## Home_TeamVALLADOLID            1.209e-14  7.987e-15  1.514e+00 0.130292    
## Home_TeamVILLARREAL            2.666e-14  6.101e-15  4.370e+00 1.30e-05 ***
## Away_TeamALMERÍA               8.576e-15  1.037e-14  8.270e-01 0.408383    
## Away_TeamATHLETIC              2.122e-15  6.005e-15  3.530e-01 0.723882    
## Away_TeamATLETICO MADRID       2.196e-14  6.075e-15  3.615e+00 0.000308 ***
## Away_TeamBARCELONA            -6.251e-14  7.084e-15 -8.824e+00  < 2e-16 ***
## Away_TeamCELTA                 9.182e-15  6.102e-15  1.505e+00 0.132539    
## Away_TeamCÓRDOBA               1.043e-14  1.038e-14  1.005e+00 0.315128    
## Away_TeamDEPORTIVO             1.003e-14  6.611e-15  1.517e+00 0.129299    
## Away_TeamEIBAR                 2.040e-14  6.063e-15  3.364e+00 0.000781 ***
## Away_TeamELCHE                 1.337e-14  1.037e-14  1.289e+00 0.197686    
## Away_TeamESPANYOL              2.366e-16  5.934e-15  4.000e-02 0.968205    
## Away_TeamGETAFE               -1.128e-14  6.240e-15 -1.808e+00 0.070712 .  
## Away_TeamGIJÓN                -3.893e-15  8.000e-15 -4.870e-01 0.626537    
## Away_TeamGIRONA                1.645e-14  7.926e-15  2.075e+00 0.038097 *  
## Away_TeamGRANADA               3.232e-15  6.513e-15  4.960e-01 0.619789    
## Away_TeamHUESCA               -8.399e-15  1.015e-14 -8.280e-01 0.408002    
## Away_TeamLAS PALMAS            2.448e-14  7.315e-15  3.346e+00 0.000834 ***
## Away_TeamLEGANÉS              -5.181e-17  6.454e-15 -8.000e-03 0.993596    
## Away_TeamLEVANTE               3.237e-15  6.156e-15  5.260e-01 0.599098    
## Away_TeamMÁLAGA                5.105e-15  6.585e-15  7.750e-01 0.438267    
## Away_TeamMALLORCA              1.801e-14  1.023e-14  1.761e+00 0.078394 .  
## Away_TeamOSASUNA              -1.724e-15  7.911e-15 -2.180e-01 0.827489    
## Away_TeamRAYO VALLECANO       -1.662e-14  7.242e-15 -2.295e+00 0.021811 *  
## Away_TeamREAL BETIS            4.912e-15  6.397e-15  7.680e-01 0.442688    
## Away_TeamREAL MADRID           1.544e-14  6.605e-15  2.338e+00 0.019483 *  
## Away_TeamREAL SOCIEDAD         3.695e-15  6.096e-15  6.060e-01 0.544483    
## Away_TeamSEVILLA FC            8.350e-15  6.098e-15  1.369e+00 0.171048    
## Away_TeamVALENCIA              5.095e-15  6.060e-15  8.410e-01 0.400528    
## Away_TeamVALLADOLID            7.520e-15  7.933e-15  9.480e-01 0.343224    
## Away_TeamVILLARREAL            3.972e-15  6.055e-15  6.560e-01 0.511879    
## `Home_Team_Possession_%`       4.632e-16  3.076e-16  1.506e+00 0.132261    
## `Away_Team_Possession_%`              NA         NA         NA       NA    
## Home_Team_Off_Target_Shots     1.935e-15  4.650e-15  4.160e-01 0.677327    
## Home_Team_On_Target_Shots      3.656e-16  4.651e-15  7.900e-02 0.937355    
## Home_Team_Total_Shots         -1.289e-15  4.631e-15 -2.780e-01 0.780741    
## Home_Team_Blocked_Shots        1.097e-15  4.637e-15  2.370e-01 0.813007    
## Home_Team_Corners              1.692e-16  3.824e-16  4.420e-01 0.658200    
## Home_Team_Throw_Ins           -2.690e-16  1.671e-16 -1.610e+00 0.107647    
## `Home_Team_Pass_Success_%`    -1.888e-15  3.276e-16 -5.761e+00 9.52e-09 ***
## Home_Team_Aerials_Won          1.000e+00  1.740e-16  5.747e+15  < 2e-16 ***
## Home_Team_Clearances           2.143e-16  1.482e-16  1.446e+00 0.148368    
## Home_Team_Fouls                3.788e-16  2.436e-16  1.555e+00 0.120037    
## Home_Team_Yellow_Cards        -3.871e-17  6.251e-16 -6.200e-02 0.950620    
## Home_Team_Second_Yellow_Cards  3.306e-15  3.566e-15  9.270e-01 0.354000    
## Home_Team_Red_Cards           -2.979e-14  3.868e-15 -7.701e+00 2.04e-14 ***
## Away_Team_Off_Target_Shots    -1.096e-15  3.994e-15 -2.740e-01 0.783827    
## Away_Team_On_Target_Shots     -1.942e-15  4.010e-15 -4.840e-01 0.628343    
## Away_Team_Total_Shots          1.630e-15  3.980e-15  4.090e-01 0.682291    
## Away_Team_Blocked_Shots       -1.912e-15  4.012e-15 -4.760e-01 0.633784    
## Away_Team_Corners             -2.189e-16  4.185e-16 -5.230e-01 0.600876    
## Away_Team_Throw_Ins           -1.553e-16  1.787e-16 -8.690e-01 0.384972    
## `Away_Team_Pass_Success_%`    -1.052e-15  3.052e-16 -3.446e+00 0.000580 ***
## Away_Team_Aerials_Won          1.000e+00  1.719e-16  5.817e+15  < 2e-16 ***
## Away_Team_Clearances           7.167e-18  1.364e-16  5.300e-02 0.958110    
## Away_Team_Fouls                3.612e-16  2.408e-16  1.500e+00 0.133843    
## Away_Team_Yellow_Cards         3.082e-16  6.356e-16  4.850e-01 0.627847    
## Away_Team_Second_Yellow_Cards -2.030e-15  3.077e-15 -6.600e-01 0.509526    
## Away_Team_Red_Cards            1.201e-15  3.789e-15  3.170e-01 0.751246    
## Home_Team_Goals_Scored         1.478e-15  1.094e-15  1.350e+00 0.177010    
## Away_Team_Goals_Scored         3.674e-16  1.236e-15  2.970e-01 0.766345    
## year                          -9.746e-14  1.125e-13 -8.660e-01 0.386574    
## resultado2                     8.638e-15  3.899e-15  2.215e+00 0.026848 *  
## resultadox                     5.450e-15  2.747e-15  1.984e+00 0.047417 *  
## goles                                 NA         NA         NA       NA    
## total_disparos                        NA         NA         NA       NA    
## total_disparos_bloqueados             NA         NA         NA       NA    
## total_corners                         NA         NA         NA       NA    
## total_centros                         NA         NA         NA       NA    
## total_despejes                        NA         NA         NA       NA    
## total_faltas                          NA         NA         NA       NA    
## total_amarillas                       NA         NA         NA       NA    
## total_rojas                           NA         NA         NA       NA    
## Home_points                           NA         NA         NA       NA    
## Away_points                           NA         NA         NA       NA    
## jornada                       -2.441e-15  2.962e-15 -8.240e-01 0.409861    
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 3.925e-14 on 2187 degrees of freedom
## Multiple R-squared:      1,  Adjusted R-squared:      1 
## F-statistic: 2.847e+30 on 92 and 2187 DF,  p-value: < 2.2e-16
lm_despejes <- lm(total_despejes~., data = train)
summary(lm_despejes)
## Warning in summary.lm(lm_despejes): essentially perfect fit: summary may be
## unreliable
## 
## Call:
## lm(formula = total_despejes ~ ., data = train)
## 
## Residuals:
##        Min         1Q     Median         3Q        Max 
## -1.384e-12 -6.370e-15 -4.700e-16  6.720e-15  3.155e-13 
## 
## Coefficients: (12 not defined because of singularities)
##                                 Estimate Std. Error    t value Pr(>|t|)    
## (Intercept)                    2.451e-10  2.380e-10  1.030e+00 0.303274    
## ...1                           3.139e-16  3.109e-16  1.009e+00 0.312853    
## Home_TeamALMERÍA               3.201e-14  1.090e-14  2.937e+00 0.003349 ** 
## Home_TeamATHLETIC              4.102e-14  6.300e-15  6.510e+00 9.29e-11 ***
## Home_TeamATLETICO MADRID       2.567e-14  6.376e-15  4.027e+00 5.85e-05 ***
## Home_TeamBARCELONA             1.654e-14  7.408e-15  2.233e+00 0.025672 *  
## Home_TeamCELTA                 2.956e-14  6.490e-15  4.556e+00 5.51e-06 ***
## Home_TeamCÓRDOBA               2.082e-14  1.091e-14  1.909e+00 0.056414 .  
## Home_TeamDEPORTIVO             2.790e-14  6.921e-15  4.031e+00 5.73e-05 ***
## Home_TeamEIBAR                 3.734e-14  6.424e-15  5.812e+00 7.07e-09 ***
## Home_TeamELCHE                 1.135e-14  1.093e-14  1.038e+00 0.299429    
## Home_TeamESPANYOL              1.398e-14  6.237e-15  2.242e+00 0.025047 *  
## Home_TeamGETAFE                6.179e-15  6.566e-15  9.410e-01 0.346799    
## Home_TeamGIJÓN                 2.463e-14  8.475e-15  2.906e+00 0.003701 ** 
## Home_TeamGIRONA                2.812e-14  8.334e-15  3.374e+00 0.000754 ***
## Home_TeamGRANADA               1.265e-14  6.841e-15  1.849e+00 0.064597 .  
## Home_TeamHUESCA                3.474e-14  1.071e-14  3.242e+00 0.001203 ** 
## Home_TeamLAS PALMAS            3.224e-14  7.807e-15  4.130e+00 3.76e-05 ***
## Home_TeamLEGANÉS               2.053e-14  6.779e-15  3.028e+00 0.002493 ** 
## Home_TeamLEVANTE               2.802e-14  6.507e-15  4.306e+00 1.74e-05 ***
## Home_TeamMÁLAGA                8.625e-15  6.907e-15  1.249e+00 0.211885    
## Home_TeamMALLORCA              1.020e-14  1.075e-14  9.490e-01 0.342750    
## Home_TeamOSASUNA               2.575e-14  8.381e-15  3.072e+00 0.002153 ** 
## Home_TeamRAYO VALLECANO        2.180e-14  7.597e-15  2.869e+00 0.004153 ** 
## Home_TeamREAL BETIS            2.531e-14  6.727e-15  3.763e+00 0.000173 ***
## Home_TeamREAL MADRID           3.311e-14  7.042e-15  4.703e+00 2.73e-06 ***
## Home_TeamREAL SOCIEDAD         3.010e-14  6.424e-15  4.685e+00 2.97e-06 ***
## Home_TeamSEVILLA FC            4.758e-14  6.522e-15  7.295e+00 4.15e-13 ***
## Home_TeamVALENCIA              1.910e-14  6.400e-15  2.985e+00 0.002870 ** 
## Home_TeamVALLADOLID            1.335e-14  8.387e-15  1.592e+00 0.111610    
## Home_TeamVILLARREAL            1.935e-14  6.406e-15  3.020e+00 0.002557 ** 
## Away_TeamALMERÍA              -2.942e-14  1.089e-14 -2.701e+00 0.006958 ** 
## Away_TeamATHLETIC             -4.387e-14  6.306e-15 -6.956e+00 4.60e-12 ***
## Away_TeamATLETICO MADRID      -4.127e-14  6.379e-15 -6.469e+00 1.21e-10 ***
## Away_TeamBARCELONA            -3.339e-14  7.439e-15 -4.489e+00 7.53e-06 ***
## Away_TeamCELTA                -2.867e-14  6.408e-15 -4.474e+00 8.08e-06 ***
## Away_TeamCÓRDOBA               4.079e-15  1.090e-14  3.740e-01 0.708180    
## Away_TeamDEPORTIVO            -2.138e-14  6.942e-15 -3.080e+00 0.002094 ** 
## Away_TeamEIBAR                -3.296e-14  6.367e-15 -5.177e+00 2.47e-07 ***
## Away_TeamELCHE                -2.126e-14  1.089e-14 -1.951e+00 0.051152 .  
## Away_TeamESPANYOL             -1.810e-14  6.232e-15 -2.905e+00 0.003709 ** 
## Away_TeamGETAFE               -1.719e-14  6.553e-15 -2.623e+00 0.008787 ** 
## Away_TeamGIJÓN                -7.920e-15  8.400e-15 -9.430e-01 0.345900    
## Away_TeamGIRONA               -1.502e-14  8.323e-15 -1.805e+00 0.071234 .  
## Away_TeamGRANADA              -1.483e-14  6.839e-15 -2.168e+00 0.030290 *  
## Away_TeamHUESCA               -3.403e-15  1.066e-14 -3.190e-01 0.749555    
## Away_TeamLAS PALMAS           -4.276e-14  7.682e-15 -5.567e+00 2.91e-08 ***
## Away_TeamLEGANÉS              -2.122e-14  6.778e-15 -3.131e+00 0.001764 ** 
## Away_TeamLEVANTE              -1.499e-14  6.464e-15 -2.319e+00 0.020486 *  
## Away_TeamMÁLAGA               -2.776e-14  6.915e-15 -4.015e+00 6.16e-05 ***
## Away_TeamMALLORCA             -2.882e-14  1.074e-14 -2.683e+00 0.007354 ** 
## Away_TeamOSASUNA              -6.623e-15  8.308e-15 -7.970e-01 0.425434    
## Away_TeamRAYO VALLECANO       -2.297e-14  7.605e-15 -3.021e+00 0.002550 ** 
## Away_TeamREAL BETIS           -2.025e-14  6.718e-15 -3.014e+00 0.002608 ** 
## Away_TeamREAL MADRID          -6.095e-14  6.936e-15 -8.787e+00  < 2e-16 ***
## Away_TeamREAL SOCIEDAD        -2.286e-14  6.401e-15 -3.571e+00 0.000363 ***
## Away_TeamSEVILLA FC           -2.705e-14  6.403e-15 -4.225e+00 2.49e-05 ***
## Away_TeamVALENCIA             -8.078e-15  6.364e-15 -1.269e+00 0.204402    
## Away_TeamVALLADOLID           -3.326e-15  8.330e-15 -3.990e-01 0.689731    
## Away_TeamVILLARREAL           -9.608e-15  6.358e-15 -1.511e+00 0.130904    
## `Home_Team_Possession_%`      -9.239e-16  3.230e-16 -2.860e+00 0.004271 ** 
## `Away_Team_Possession_%`              NA         NA         NA       NA    
## Home_Team_Off_Target_Shots     4.263e-16  4.883e-15  8.700e-02 0.930446    
## Home_Team_On_Target_Shots      1.082e-15  4.884e-15  2.220e-01 0.824636    
## Home_Team_Total_Shots         -3.808e-17  4.863e-15 -8.000e-03 0.993752    
## Home_Team_Blocked_Shots        8.539e-16  4.870e-15  1.750e-01 0.860819    
## Home_Team_Corners             -9.671e-16  4.016e-16 -2.408e+00 0.016108 *  
## Home_Team_Throw_Ins            1.130e-15  1.755e-16  6.439e+00 1.48e-10 ***
## `Home_Team_Pass_Success_%`    -3.685e-17  3.440e-16 -1.070e-01 0.914715    
## Home_Team_Aerials_Won          5.874e-17  1.827e-16  3.210e-01 0.747889    
## Home_Team_Clearances           1.000e+00  1.556e-16  6.425e+15  < 2e-16 ***
## Home_Team_Fouls                2.125e-16  2.558e-16  8.310e-01 0.406140    
## Home_Team_Yellow_Cards         7.219e-16  6.564e-16  1.100e+00 0.271556    
## Home_Team_Second_Yellow_Cards  1.355e-15  3.745e-15  3.620e-01 0.717628    
## Home_Team_Red_Cards           -2.667e-14  4.062e-15 -6.565e+00 6.48e-11 ***
## Away_Team_Off_Target_Shots     4.238e-15  4.194e-15  1.011e+00 0.312341    
## Away_Team_On_Target_Shots      3.139e-15  4.211e-15  7.450e-01 0.456087    
## Away_Team_Total_Shots         -3.236e-15  4.180e-15 -7.740e-01 0.438864    
## Away_Team_Blocked_Shots        3.412e-15  4.213e-15  8.100e-01 0.418137    
## Away_Team_Corners             -4.319e-16  4.394e-16 -9.830e-01 0.325806    
## Away_Team_Throw_Ins            2.197e-17  1.876e-16  1.170e-01 0.906789    
## `Away_Team_Pass_Success_%`     2.711e-16  3.205e-16  8.460e-01 0.397639    
## Away_Team_Aerials_Won          1.230e-16  1.805e-16  6.820e-01 0.495582    
## Away_Team_Clearances           1.000e+00  1.433e-16  6.980e+15  < 2e-16 ***
## Away_Team_Fouls                1.961e-16  2.529e-16  7.750e-01 0.438175    
## Away_Team_Yellow_Cards         1.458e-16  6.674e-16  2.180e-01 0.827112    
## Away_Team_Second_Yellow_Cards  3.318e-16  3.232e-15  1.030e-01 0.918225    
## Away_Team_Red_Cards            8.245e-15  3.979e-15  2.072e+00 0.038387 *  
## Home_Team_Goals_Scored        -6.771e-17  1.149e-15 -5.900e-02 0.953017    
## Away_Team_Goals_Scored         1.123e-15  1.298e-15  8.650e-01 0.387204    
## year                          -1.217e-13  1.182e-13 -1.030e+00 0.303166    
## resultado2                     2.855e-15  4.095e-15  6.970e-01 0.485762    
## resultadox                     2.584e-16  2.885e-15  9.000e-02 0.928632    
## goles                                 NA         NA         NA       NA    
## total_disparos                        NA         NA         NA       NA    
## total_disparos_bloqueados             NA         NA         NA       NA    
## total_corners                         NA         NA         NA       NA    
## total_centros                         NA         NA         NA       NA    
## total_d_aereos                        NA         NA         NA       NA    
## total_faltas                          NA         NA         NA       NA    
## total_amarillas                       NA         NA         NA       NA    
## total_rojas                           NA         NA         NA       NA    
## Home_points                           NA         NA         NA       NA    
## Away_points                           NA         NA         NA       NA    
## jornada                       -2.994e-15  3.110e-15 -9.630e-01 0.335786    
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 4.122e-14 on 2187 degrees of freedom
## Multiple R-squared:      1,  Adjusted R-squared:      1 
## F-statistic: 1.858e+30 on 92 and 2187 DF,  p-value: < 2.2e-16
lm_faltas <- lm(total_faltas~., data = train)
summary(lm_faltas)
## 
## Call:
## lm(formula = total_faltas ~ ., data = train)
## 
## Residuals:
##        Min         1Q     Median         3Q        Max 
## -6.540e-13 -1.200e-14  6.000e-15  2.250e-14  7.834e-12 
## 
## Coefficients: (12 not defined because of singularities)
##                                 Estimate Std. Error    t value Pr(>|t|)    
## (Intercept)                   -2.030e-09  1.006e-09 -2.018e+00  0.04374 *  
## ...1                          -2.666e-15  1.315e-15 -2.028e+00  0.04268 *  
## Home_TeamALMERÍA              -3.147e-14  4.608e-14 -6.830e-01  0.49466    
## Home_TeamATHLETIC             -1.332e-14  2.664e-14 -5.000e-01  0.61719    
## Home_TeamATLETICO MADRID      -1.377e-14  2.695e-14 -5.110e-01  0.60952    
## Home_TeamBARCELONA            -3.961e-14  3.132e-14 -1.265e+00  0.20614    
## Home_TeamCELTA                -2.154e-14  2.744e-14 -7.850e-01  0.43250    
## Home_TeamCÓRDOBA              -1.465e-14  4.611e-14 -3.180e-01  0.75071    
## Home_TeamDEPORTIVO            -1.459e-14  2.926e-14 -4.990e-01  0.61803    
## Home_TeamEIBAR                -1.863e-14  2.716e-14 -6.860e-01  0.49276    
## Home_TeamELCHE                -1.212e-14  4.622e-14 -2.620e-01  0.79320    
## Home_TeamESPANYOL             -4.794e-15  2.637e-14 -1.820e-01  0.85574    
## Home_TeamGETAFE               -2.246e-14  2.776e-14 -8.090e-01  0.41850    
## Home_TeamGIJÓN                -2.376e-14  3.583e-14 -6.630e-01  0.50736    
## Home_TeamGIRONA                5.732e-15  3.523e-14  1.630e-01  0.87079    
## Home_TeamGRANADA              -6.143e-15  2.892e-14 -2.120e-01  0.83181    
## Home_TeamHUESCA                3.974e-15  4.529e-14  8.800e-02  0.93008    
## Home_TeamLAS PALMAS           -1.534e-14  3.301e-14 -4.650e-01  0.64207    
## Home_TeamLEGANÉS              -1.316e-14  2.866e-14 -4.590e-01  0.64628    
## Home_TeamLEVANTE              -2.566e-14  2.751e-14 -9.330e-01  0.35105    
## Home_TeamMÁLAGA                8.515e-14  2.920e-14  2.916e+00  0.00358 ** 
## Home_TeamMALLORCA             -1.205e-14  4.546e-14 -2.650e-01  0.79101    
## Home_TeamOSASUNA              -1.714e-14  3.543e-14 -4.840e-01  0.62855    
## Home_TeamRAYO VALLECANO       -2.052e-14  3.212e-14 -6.390e-01  0.52296    
## Home_TeamREAL BETIS           -1.883e-14  2.844e-14 -6.620e-01  0.50804    
## Home_TeamREAL MADRID          -2.790e-14  2.977e-14 -9.370e-01  0.34884    
## Home_TeamREAL SOCIEDAD        -1.570e-14  2.716e-14 -5.780e-01  0.56320    
## Home_TeamSEVILLA FC           -9.330e-15  2.757e-14 -3.380e-01  0.73509    
## Home_TeamVALENCIA             -1.069e-14  2.706e-14 -3.950e-01  0.69269    
## Home_TeamVALLADOLID           -9.416e-15  3.546e-14 -2.660e-01  0.79062    
## Home_TeamVILLARREAL           -1.324e-14  2.708e-14 -4.890e-01  0.62508    
## Away_TeamALMERÍA               7.144e-15  4.605e-14  1.550e-01  0.87672    
## Away_TeamATHLETIC              6.895e-14  2.666e-14  2.586e+00  0.00976 ** 
## Away_TeamATLETICO MADRID      -8.674e-15  2.697e-14 -3.220e-01  0.74777    
## Away_TeamBARCELONA            -1.308e-14  3.145e-14 -4.160e-01  0.67745    
## Away_TeamCELTA                -4.419e-15  2.709e-14 -1.630e-01  0.87045    
## Away_TeamCÓRDOBA              -1.860e-14  4.607e-14 -4.040e-01  0.68653    
## Away_TeamDEPORTIVO            -8.812e-16  2.935e-14 -3.000e-02  0.97605    
## Away_TeamEIBAR                -1.320e-14  2.692e-14 -4.900e-01  0.62386    
## Away_TeamELCHE                -2.374e-14  4.606e-14 -5.150e-01  0.60632    
## Away_TeamESPANYOL             -3.244e-15  2.635e-14 -1.230e-01  0.90201    
## Away_TeamGETAFE               -8.175e-15  2.770e-14 -2.950e-01  0.76797    
## Away_TeamGIJÓN                 6.303e-15  3.552e-14  1.770e-01  0.85915    
## Away_TeamGIRONA               -5.516e-15  3.519e-14 -1.570e-01  0.87543    
## Away_TeamGRANADA              -1.026e-14  2.891e-14 -3.550e-01  0.72278    
## Away_TeamHUESCA                1.033e-15  4.506e-14  2.300e-02  0.98172    
## Away_TeamLAS PALMAS           -4.880e-15  3.248e-14 -1.500e-01  0.88056    
## Away_TeamLEGANÉS              -5.360e-15  2.865e-14 -1.870e-01  0.85162    
## Away_TeamLEVANTE              -9.317e-15  2.733e-14 -3.410e-01  0.73320    
## Away_TeamMÁLAGA               -7.351e-16  2.924e-14 -2.500e-02  0.97994    
## Away_TeamMALLORCA              9.031e-15  4.541e-14  1.990e-01  0.84236    
## Away_TeamOSASUNA              -2.775e-15  3.512e-14 -7.900e-02  0.93703    
## Away_TeamRAYO VALLECANO       -8.693e-15  3.215e-14 -2.700e-01  0.78691    
## Away_TeamREAL BETIS           -1.095e-14  2.840e-14 -3.860e-01  0.69977    
## Away_TeamREAL MADRID           9.321e-15  2.932e-14  3.180e-01  0.75061    
## Away_TeamREAL SOCIEDAD         1.415e-15  2.706e-14  5.200e-02  0.95831    
## Away_TeamSEVILLA FC           -3.217e-15  2.707e-14 -1.190e-01  0.90541    
## Away_TeamVALENCIA              1.320e-14  2.690e-14  4.910e-01  0.62379    
## Away_TeamVALLADOLID            7.821e-15  3.522e-14  2.220e-01  0.82429    
## Away_TeamVILLARREAL           -3.457e-15  2.688e-14 -1.290e-01  0.89767    
## `Home_Team_Possession_%`       1.887e-15  1.366e-15  1.382e+00  0.16719    
## `Away_Team_Possession_%`              NA         NA         NA       NA    
## Home_Team_Off_Target_Shots    -1.500e-15  2.065e-14 -7.300e-02  0.94210    
## Home_Team_On_Target_Shots     -2.531e-15  2.065e-14 -1.230e-01  0.90246    
## Home_Team_Total_Shots          8.683e-16  2.056e-14  4.200e-02  0.96632    
## Home_Team_Blocked_Shots        1.490e-15  2.059e-14  7.200e-02  0.94229    
## Home_Team_Corners             -1.493e-16  1.698e-15 -8.800e-02  0.92994    
## Home_Team_Throw_Ins           -1.454e-15  7.421e-16 -1.960e+00  0.05014 .  
## `Home_Team_Pass_Success_%`    -3.372e-15  1.454e-15 -2.318e+00  0.02052 *  
## Home_Team_Aerials_Won         -9.033e-17  7.726e-16 -1.170e-01  0.90693    
## Home_Team_Clearances          -8.960e-16  6.581e-16 -1.362e+00  0.17347    
## Home_Team_Fouls                1.000e+00  1.081e-15  9.248e+14  < 2e-16 ***
## Home_Team_Yellow_Cards         1.551e-15  2.775e-15  5.590e-01  0.57628    
## Home_Team_Second_Yellow_Cards  1.594e-15  1.583e-14  1.010e-01  0.91980    
## Home_Team_Red_Cards            1.545e-13  1.717e-14  8.996e+00  < 2e-16 ***
## Away_Team_Off_Target_Shots    -4.290e-15  1.773e-14 -2.420e-01  0.80885    
## Away_Team_On_Target_Shots     -3.038e-16  1.780e-14 -1.700e-02  0.98639    
## Away_Team_Total_Shots          3.031e-15  1.767e-14  1.720e-01  0.86384    
## Away_Team_Blocked_Shots       -4.008e-15  1.781e-14 -2.250e-01  0.82199    
## Away_Team_Corners             -6.562e-16  1.858e-15 -3.530e-01  0.72397    
## Away_Team_Throw_Ins           -4.620e-16  7.933e-16 -5.820e-01  0.56041    
## `Away_Team_Pass_Success_%`     1.370e-15  1.355e-15  1.011e+00  0.31219    
## Away_Team_Aerials_Won          1.273e-17  7.633e-16  1.700e-02  0.98669    
## Away_Team_Clearances          -4.490e-16  6.057e-16 -7.410e-01  0.45857    
## Away_Team_Fouls                1.000e+00  1.069e-15  9.352e+14  < 2e-16 ***
## Away_Team_Yellow_Cards         2.631e-16  2.822e-15  9.300e-02  0.92572    
## Away_Team_Second_Yellow_Cards -3.285e-15  1.366e-14 -2.400e-01  0.81002    
## Away_Team_Red_Cards           -1.634e-14  1.682e-14 -9.710e-01  0.33149    
## Home_Team_Goals_Scored        -4.073e-15  4.858e-15 -8.380e-01  0.40189    
## Away_Team_Goals_Scored        -3.635e-15  5.489e-15 -6.620e-01  0.50790    
## year                           1.008e-12  4.996e-13  2.018e+00  0.04369 *  
## resultado2                    -3.153e-14  1.731e-14 -1.821e+00  0.06869 .  
## resultadox                    -2.001e-14  1.220e-14 -1.640e+00  0.10106    
## goles                                 NA         NA         NA       NA    
## total_disparos                        NA         NA         NA       NA    
## total_disparos_bloqueados             NA         NA         NA       NA    
## total_corners                         NA         NA         NA       NA    
## total_centros                         NA         NA         NA       NA    
## total_d_aereos                        NA         NA         NA       NA    
## total_despejes                        NA         NA         NA       NA    
## total_amarillas                       NA         NA         NA       NA    
## total_rojas                           NA         NA         NA       NA    
## Home_points                           NA         NA         NA       NA    
## Away_points                           NA         NA         NA       NA    
## jornada                        2.605e-14  1.315e-14  1.981e+00  0.04773 *  
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 1.743e-13 on 2187 degrees of freedom
## Multiple R-squared:      1,  Adjusted R-squared:      1 
## F-statistic: 2.84e+28 on 92 and 2187 DF,  p-value: < 2.2e-16
lm_amarillas <- lm(total_amarillas~., data = train)
summary(lm_amarillas)
## 
## Call:
## lm(formula = total_amarillas ~ ., data = train)
## 
## Residuals:
##        Min         1Q     Median         3Q        Max 
## -3.378e-12 -9.500e-15 -2.300e-15  5.500e-15  1.379e-13 
## 
## Coefficients: (12 not defined because of singularities)
##                                 Estimate Std. Error    t value Pr(>|t|)    
## (Intercept)                    9.795e-10  4.328e-10  2.263e+00  0.02373 *  
## ...1                           1.286e-15  5.655e-16  2.275e+00  0.02301 *  
## Home_TeamALMERÍA               1.301e-15  1.982e-14  6.600e-02  0.94767    
## Home_TeamATHLETIC             -7.515e-16  1.146e-14 -6.600e-02  0.94771    
## Home_TeamATLETICO MADRID       3.251e-15  1.159e-14  2.800e-01  0.77919    
## Home_TeamBARCELONA             6.030e-15  1.347e-14  4.480e-01  0.65448    
## Home_TeamCELTA                 3.854e-15  1.180e-14  3.270e-01  0.74405    
## Home_TeamCÓRDOBA               7.879e-16  1.984e-14  4.000e-02  0.96832    
## Home_TeamDEPORTIVO             2.029e-15  1.259e-14  1.610e-01  0.87194    
## Home_TeamEIBAR                -1.122e-15  1.168e-14 -9.600e-02  0.92348    
## Home_TeamELCHE                 7.758e-15  1.988e-14  3.900e-01  0.69638    
## Home_TeamESPANYOL             -5.897e-17  1.134e-14 -5.000e-03  0.99585    
## Home_TeamGETAFE                3.458e-15  1.194e-14  2.900e-01  0.77214    
## Home_TeamGIJÓN                 9.729e-15  1.541e-14  6.310e-01  0.52800    
## Home_TeamGIRONA               -3.542e-15  1.516e-14 -2.340e-01  0.81523    
## Home_TeamGRANADA               1.389e-15  1.244e-14  1.120e-01  0.91110    
## Home_TeamHUESCA               -7.080e-15  1.948e-14 -3.630e-01  0.71636    
## Home_TeamLAS PALMAS            3.694e-16  1.420e-14  2.600e-02  0.97925    
## Home_TeamLEGANÉS               2.749e-15  1.233e-14  2.230e-01  0.82357    
## Home_TeamLEVANTE               4.085e-15  1.183e-14  3.450e-01  0.72999    
## Home_TeamMÁLAGA               -3.942e-14  1.256e-14 -3.138e+00  0.00172 ** 
## Home_TeamMALLORCA             -7.127e-16  1.955e-14 -3.600e-02  0.97093    
## Home_TeamOSASUNA              -1.124e-15  1.524e-14 -7.400e-02  0.94123    
## Home_TeamRAYO VALLECANO        3.938e-15  1.382e-14  2.850e-01  0.77563    
## Home_TeamREAL BETIS            4.570e-15  1.223e-14  3.740e-01  0.70877    
## Home_TeamREAL MADRID           1.229e-14  1.281e-14  9.600e-01  0.33722    
## Home_TeamREAL SOCIEDAD         4.884e-17  1.168e-14  4.000e-03  0.99666    
## Home_TeamSEVILLA FC            2.286e-15  1.186e-14  1.930e-01  0.84718    
## Home_TeamVALENCIA              4.268e-15  1.164e-14  3.670e-01  0.71389    
## Home_TeamVALLADOLID           -5.953e-15  1.525e-14 -3.900e-01  0.69637    
## Home_TeamVILLARREAL            4.532e-15  1.165e-14  3.890e-01  0.69733    
## Away_TeamALMERÍA              -3.538e-15  1.981e-14 -1.790e-01  0.85824    
## Away_TeamATHLETIC             -3.177e-14  1.147e-14 -2.771e+00  0.00564 ** 
## Away_TeamATLETICO MADRID      -8.686e-16  1.160e-14 -7.500e-02  0.94033    
## Away_TeamBARCELONA             1.005e-14  1.353e-14  7.420e-01  0.45787    
## Away_TeamCELTA                 4.682e-16  1.165e-14  4.000e-02  0.96796    
## Away_TeamCÓRDOBA               6.019e-15  1.982e-14  3.040e-01  0.76139    
## Away_TeamDEPORTIVO            -7.317e-16  1.263e-14 -5.800e-02  0.95379    
## Away_TeamEIBAR                -3.252e-15  1.158e-14 -2.810e-01  0.77884    
## Away_TeamELCHE                 1.286e-14  1.981e-14  6.490e-01  0.51622    
## Away_TeamESPANYOL              3.095e-15  1.133e-14  2.730e-01  0.78480    
## Away_TeamGETAFE               -2.544e-15  1.192e-14 -2.130e-01  0.83098    
## Away_TeamGIJÓN                -2.544e-15  1.528e-14 -1.670e-01  0.86774    
## Away_TeamGIRONA                2.754e-15  1.514e-14  1.820e-01  0.85565    
## Away_TeamGRANADA               2.812e-15  1.244e-14  2.260e-01  0.82118    
## Away_TeamHUESCA               -4.211e-15  1.938e-14 -2.170e-01  0.82801    
## Away_TeamLAS PALMAS            8.474e-15  1.397e-14  6.070e-01  0.54422    
## Away_TeamLEGANÉS              -1.698e-15  1.233e-14 -1.380e-01  0.89047    
## Away_TeamLEVANTE               6.854e-16  1.176e-14  5.800e-02  0.95351    
## Away_TeamMÁLAGA               -2.307e-16  1.258e-14 -1.800e-02  0.98537    
## Away_TeamMALLORCA              1.503e-15  1.953e-14  7.700e-02  0.93866    
## Away_TeamOSASUNA              -4.290e-15  1.511e-14 -2.840e-01  0.77647    
## Away_TeamRAYO VALLECANO        3.420e-15  1.383e-14  2.470e-01  0.80474    
## Away_TeamREAL BETIS            8.013e-15  1.222e-14  6.560e-01  0.51200    
## Away_TeamREAL MADRID           1.977e-15  1.261e-14  1.570e-01  0.87546    
## Away_TeamREAL SOCIEDAD        -1.587e-15  1.164e-14 -1.360e-01  0.89160    
## Away_TeamSEVILLA FC            2.325e-15  1.165e-14  2.000e-01  0.84179    
## Away_TeamVALENCIA              2.787e-15  1.157e-14  2.410e-01  0.80972    
## Away_TeamVALLADOLID            3.643e-15  1.515e-14  2.400e-01  0.81001    
## Away_TeamVILLARREAL            1.259e-16  1.156e-14  1.100e-02  0.99132    
## `Home_Team_Possession_%`      -5.458e-16  5.874e-16 -9.290e-01  0.35287    
## `Away_Team_Possession_%`              NA         NA         NA       NA    
## Home_Team_Off_Target_Shots     5.194e-16  8.881e-15  5.800e-02  0.95337    
## Home_Team_On_Target_Shots      1.182e-15  8.882e-15  1.330e-01  0.89412    
## Home_Team_Total_Shots         -8.296e-16  8.844e-15 -9.400e-02  0.92528    
## Home_Team_Blocked_Shots       -6.959e-17  8.856e-15 -8.000e-03  0.99373    
## Home_Team_Corners              4.995e-17  7.303e-16  6.800e-02  0.94547    
## Home_Team_Throw_Ins            4.980e-16  3.192e-16  1.560e+00  0.11889    
## `Home_Team_Pass_Success_%`     5.894e-16  6.257e-16  9.420e-01  0.34632    
## Home_Team_Aerials_Won          3.245e-17  3.323e-16  9.800e-02  0.92223    
## Home_Team_Clearances           3.430e-16  2.831e-16  1.212e+00  0.22576    
## Home_Team_Fouls                1.636e-16  4.651e-16  3.520e-01  0.72509    
## Home_Team_Yellow_Cards         1.000e+00  1.194e-15  8.377e+14  < 2e-16 ***
## Home_Team_Second_Yellow_Cards  8.731e-17  6.811e-15  1.300e-02  0.98977    
## Home_Team_Red_Cards           -6.648e-14  7.388e-15 -8.999e+00  < 2e-16 ***
## Away_Team_Off_Target_Shots     7.694e-16  7.627e-15  1.010e-01  0.91966    
## Away_Team_On_Target_Shots     -7.360e-16  7.659e-15 -9.600e-02  0.92345    
## Away_Team_Total_Shots         -1.148e-16  7.601e-15 -1.500e-02  0.98795    
## Away_Team_Blocked_Shots        5.295e-16  7.662e-15  6.900e-02  0.94491    
## Away_Team_Corners              3.664e-16  7.991e-16  4.580e-01  0.64669    
## Away_Team_Throw_Ins            1.768e-16  3.413e-16  5.180e-01  0.60436    
## `Away_Team_Pass_Success_%`    -7.188e-16  5.828e-16 -1.233e+00  0.21761    
## Away_Team_Aerials_Won         -1.078e-17  3.283e-16 -3.300e-02  0.97382    
## Away_Team_Clearances           1.967e-16  2.606e-16  7.550e-01  0.45027    
## Away_Team_Fouls                4.396e-16  4.600e-16  9.560e-01  0.33936    
## Away_Team_Yellow_Cards         1.000e+00  1.214e-15  8.238e+14  < 2e-16 ***
## Away_Team_Second_Yellow_Cards  2.385e-15  5.877e-15  4.060e-01  0.68491    
## Away_Team_Red_Cards            6.626e-15  7.237e-15  9.160e-01  0.35995    
## Home_Team_Goals_Scored         1.783e-15  2.090e-15  8.530e-01  0.39370    
## Away_Team_Goals_Scored         1.707e-15  2.361e-15  7.230e-01  0.46978    
## year                          -4.864e-13  2.149e-13 -2.263e+00  0.02372 *  
## resultado2                     1.172e-14  7.447e-15  1.574e+00  0.11573    
## resultadox                     8.315e-15  5.247e-15  1.585e+00  0.11312    
## goles                                 NA         NA         NA       NA    
## total_disparos                        NA         NA         NA       NA    
## total_disparos_bloqueados             NA         NA         NA       NA    
## total_corners                         NA         NA         NA       NA    
## total_centros                         NA         NA         NA       NA    
## total_d_aereos                        NA         NA         NA       NA    
## total_despejes                        NA         NA         NA       NA    
## total_faltas                          NA         NA         NA       NA    
## total_rojas                           NA         NA         NA       NA    
## Home_points                           NA         NA         NA       NA    
## Away_points                           NA         NA         NA       NA    
## jornada                       -1.258e-14  5.656e-15 -2.224e+00  0.02628 *  
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 7.497e-14 on 2187 degrees of freedom
## Multiple R-squared:      1,  Adjusted R-squared:      1 
## F-statistic: 2.286e+28 on 92 and 2187 DF,  p-value: < 2.2e-16
lm_rojas <- lm(total_rojas~., data = train)
summary(lm_rojas)
## 
## Call:
## lm(formula = total_rojas ~ ., data = train)
## 
## Residuals:
##        Min         1Q     Median         3Q        Max 
## -3.830e-14 -1.270e-16 -1.900e-17  9.900e-17  7.668e-15 
## 
## Coefficients: (12 not defined because of singularities)
##                                 Estimate Std. Error    t value Pr(>|t|)    
## (Intercept)                    1.363e-11  5.190e-12  2.626e+00 0.008689 ** 
## ...1                           1.794e-17  6.781e-18  2.646e+00 0.008204 ** 
## Home_TeamALMERÍA               1.421e-17  2.377e-16  6.000e-02 0.952326    
## Home_TeamATHLETIC             -6.885e-18  1.374e-16 -5.000e-02 0.960039    
## Home_TeamATLETICO MADRID       1.300e-16  1.390e-16  9.350e-01 0.349748    
## Home_TeamBARCELONA             4.289e-16  1.616e-16  2.655e+00 0.007996 ** 
## Home_TeamCELTA                 2.524e-18  1.415e-16  1.800e-02 0.985771    
## Home_TeamCÓRDOBA               2.055e-16  2.379e-16  8.640e-01 0.387801    
## Home_TeamDEPORTIVO            -1.546e-16  1.509e-16 -1.024e+00 0.305895    
## Home_TeamEIBAR                -2.960e-16  1.401e-16 -2.113e+00 0.034698 *  
## Home_TeamELCHE                -9.340e-17  2.384e-16 -3.920e-01 0.695255    
## Home_TeamESPANYOL             -1.095e-16  1.360e-16 -8.050e-01 0.420694    
## Home_TeamGETAFE               -2.765e-17  1.432e-16 -1.930e-01 0.846907    
## Home_TeamGIJÓN                -6.294e-17  1.848e-16 -3.400e-01 0.733518    
## Home_TeamGIRONA               -1.129e-16  1.818e-16 -6.210e-01 0.534692    
## Home_TeamGRANADA              -1.694e-16  1.492e-16 -1.135e+00 0.256421    
## Home_TeamHUESCA               -2.120e-16  2.336e-16 -9.070e-01 0.364271    
## Home_TeamLAS PALMAS            2.898e-17  1.703e-16  1.700e-01 0.864861    
## Home_TeamLEGANÉS               4.467e-17  1.478e-16  3.020e-01 0.762576    
## Home_TeamLEVANTE               7.530e-18  1.419e-16  5.300e-02 0.957688    
## Home_TeamMÁLAGA               -6.149e-16  1.506e-16 -4.082e+00 4.62e-05 ***
## Home_TeamMALLORCA             -5.799e-16  2.345e-16 -2.473e+00 0.013474 *  
## Home_TeamOSASUNA              -3.582e-17  1.828e-16 -1.960e-01 0.844634    
## Home_TeamRAYO VALLECANO        3.713e-17  1.657e-16  2.240e-01 0.822667    
## Home_TeamREAL BETIS           -2.032e-17  1.467e-16 -1.390e-01 0.889835    
## Home_TeamREAL MADRID          -1.111e-17  1.536e-16 -7.200e-02 0.942319    
## Home_TeamREAL SOCIEDAD         3.759e-17  1.401e-16  2.680e-01 0.788459    
## Home_TeamSEVILLA FC            5.898e-17  1.422e-16  4.150e-01 0.678401    
## Home_TeamVALENCIA              6.072e-17  1.396e-16  4.350e-01 0.663584    
## Home_TeamVALLADOLID           -2.441e-16  1.829e-16 -1.335e+00 0.182136    
## Home_TeamVILLARREAL           -4.508e-18  1.397e-16 -3.200e-02 0.974264    
## Away_TeamALMERÍA               3.662e-16  2.375e-16  1.542e+00 0.123295    
## Away_TeamATHLETIC              3.890e-17  1.375e-16  2.830e-01 0.777303    
## Away_TeamATLETICO MADRID       3.891e-16  1.391e-16  2.797e+00 0.005208 ** 
## Away_TeamBARCELONA             2.739e-16  1.622e-16  1.688e+00 0.091534 .  
## Away_TeamCELTA                 2.870e-16  1.398e-16  2.054e+00 0.040139 *  
## Away_TeamCÓRDOBA               5.004e-16  2.377e-16  2.105e+00 0.035366 *  
## Away_TeamDEPORTIVO             1.623e-16  1.514e-16  1.072e+00 0.283886    
## Away_TeamEIBAR                 1.251e-16  1.388e-16  9.010e-01 0.367500    
## Away_TeamELCHE                 9.939e-16  2.376e-16  4.183e+00 2.99e-05 ***
## Away_TeamESPANYOL              2.108e-16  1.359e-16  1.551e+00 0.120984    
## Away_TeamGETAFE                2.790e-16  1.429e-16  1.952e+00 0.051026 .  
## Away_TeamGIJÓN                 5.070e-16  1.832e-16  2.767e+00 0.005698 ** 
## Away_TeamGIRONA                2.426e-16  1.815e-16  1.336e+00 0.181548    
## Away_TeamGRANADA               3.596e-16  1.492e-16  2.411e+00 0.015986 *  
## Away_TeamHUESCA                1.213e-16  2.324e-16  5.220e-01 0.601884    
## Away_TeamLAS PALMAS            3.123e-16  1.675e-16  1.864e+00 0.062431 .  
## Away_TeamLEGANÉS               3.064e-16  1.478e-16  2.073e+00 0.038298 *  
## Away_TeamLEVANTE               2.529e-16  1.410e-16  1.794e+00 0.072944 .  
## Away_TeamMÁLAGA                2.348e-16  1.508e-16  1.557e+00 0.119669    
## Away_TeamMALLORCA              3.322e-16  2.342e-16  1.418e+00 0.156207    
## Away_TeamOSASUNA               2.864e-16  1.812e-16  1.581e+00 0.114038    
## Away_TeamRAYO VALLECANO        3.710e-16  1.658e-16  2.237e+00 0.025387 *  
## Away_TeamREAL BETIS            3.955e-16  1.465e-16  2.700e+00 0.006993 ** 
## Away_TeamREAL MADRID           1.712e-16  1.513e-16  1.132e+00 0.257881    
## Away_TeamREAL SOCIEDAD         2.628e-16  1.396e-16  1.882e+00 0.059906 .  
## Away_TeamSEVILLA FC            3.274e-16  1.396e-16  2.344e+00 0.019142 *  
## Away_TeamVALENCIA              1.758e-16  1.388e-16  1.267e+00 0.205292    
## Away_TeamVALLADOLID            1.609e-16  1.817e-16  8.850e-01 0.376020    
## Away_TeamVILLARREAL            2.999e-16  1.387e-16  2.163e+00 0.030645 *  
## `Home_Team_Possession_%`      -3.858e-18  7.044e-18 -5.480e-01 0.583990    
## `Away_Team_Possession_%`              NA         NA         NA       NA    
## Home_Team_Off_Target_Shots    -3.205e-16  1.065e-16 -3.010e+00 0.002647 ** 
## Home_Team_On_Target_Shots     -3.548e-16  1.065e-16 -3.331e+00 0.000879 ***
## Home_Team_Total_Shots          3.507e-16  1.061e-16  3.307e+00 0.000959 ***
## Home_Team_Blocked_Shots       -3.625e-16  1.062e-16 -3.413e+00 0.000655 ***
## Home_Team_Corners              9.020e-18  8.757e-18  1.030e+00 0.303160    
## Home_Team_Throw_Ins           -7.873e-19  3.828e-18 -2.060e-01 0.837064    
## `Home_Team_Pass_Success_%`     1.018e-18  7.503e-18  1.360e-01 0.892067    
## Home_Team_Aerials_Won         -1.118e-17  3.985e-18 -2.805e+00 0.005073 ** 
## Home_Team_Clearances           2.001e-18  3.394e-18  5.890e-01 0.555687    
## Home_Team_Fouls                4.558e-18  5.578e-18  8.170e-01 0.413915    
## Home_Team_Yellow_Cards        -5.983e-18  1.431e-17 -4.180e-01 0.676030    
## Home_Team_Second_Yellow_Cards -2.996e-17  8.168e-17 -3.670e-01 0.713800    
## Home_Team_Red_Cards            1.000e+00  8.859e-17  1.129e+16  < 2e-16 ***
## Away_Team_Off_Target_Shots     1.254e-17  9.146e-17  1.370e-01 0.890968    
## Away_Team_On_Target_Shots     -5.487e-18  9.184e-17 -6.000e-02 0.952368    
## Away_Team_Total_Shots         -7.730e-18  9.115e-17 -8.500e-02 0.932429    
## Away_Team_Blocked_Shots        9.257e-18  9.188e-17  1.010e-01 0.919760    
## Away_Team_Corners              1.062e-17  9.583e-18  1.108e+00 0.268105    
## Away_Team_Throw_Ins           -1.340e-18  4.092e-18 -3.270e-01 0.743402    
## `Away_Team_Pass_Success_%`    -5.331e-18  6.989e-18 -7.630e-01 0.445699    
## Away_Team_Aerials_Won          5.097e-18  3.937e-18  1.295e+00 0.195608    
## Away_Team_Clearances          -4.626e-19  3.125e-18 -1.480e-01 0.882325    
## Away_Team_Fouls                5.493e-18  5.516e-18  9.960e-01 0.319424    
## Away_Team_Yellow_Cards         1.034e-17  1.456e-17  7.100e-01 0.477659    
## Away_Team_Second_Yellow_Cards  8.658e-18  7.048e-17  1.230e-01 0.902243    
## Away_Team_Red_Cards            1.000e+00  8.678e-17  1.152e+16  < 2e-16 ***
## Home_Team_Goals_Scored         3.031e-17  2.506e-17  1.210e+00 0.226595    
## Away_Team_Goals_Scored         1.040e-17  2.831e-17  3.670e-01 0.713442    
## year                          -6.769e-15  2.577e-15 -2.627e+00 0.008684 ** 
## resultado2                     1.580e-16  8.930e-17  1.770e+00 0.076931 .  
## resultadox                     1.086e-16  6.291e-17  1.726e+00 0.084484 .  
## goles                                 NA         NA         NA       NA    
## total_disparos                        NA         NA         NA       NA    
## total_disparos_bloqueados             NA         NA         NA       NA    
## total_corners                         NA         NA         NA       NA    
## total_centros                         NA         NA         NA       NA    
## total_d_aereos                        NA         NA         NA       NA    
## total_despejes                        NA         NA         NA       NA    
## total_faltas                          NA         NA         NA       NA    
## total_amarillas                       NA         NA         NA       NA    
## Home_points                           NA         NA         NA       NA    
## Away_points                           NA         NA         NA       NA    
## jornada                       -1.768e-16  6.783e-17 -2.607e+00 0.009189 ** 
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 8.99e-16 on 2187 degrees of freedom
## Multiple R-squared:      1,  Adjusted R-squared:      1 
## F-statistic: 3.238e+30 on 92 and 2187 DF,  p-value: < 2.2e-16

REGRESION BACKWARD



# CONCLUSIONES Hay muchas variables que no afectan al resultado de un partido.
Los equipos locales ganan más.

Hay dos equipos que sobresalen (Madrid y Barsa)
Hay un grupo de equipos “buenos” (nunca han descendido, meten más goles…)

De cara al futuro:
Cuanto se parecen dos partidos?
Clusterizar equipos en buenos, medios y malos.
Incluir las rachas de victorias, dorrotas y empates.
Calcular los puntos que suma cada equipo por partido en función de ser local o visitante, del “nivel” del rival, etc.
Predecir el número de goles que va a marcar cada equipo en un partido, en vez de victoria/derrota/empate.